oracle sqlplus调用.sql文件 bat调用sql 并出力spool log

++++++++++++++++++++++++++++++++sqlplus调用.sql+++++++++++++++++++++++++++++++++

登陆sqlplus

sqlplus / as sysdba

sql>@D:test.sql

--------------------------------test.sql----------------------------------------

set echo off
--打开DBMS_OUTPUTlog

set serveroutput on
--spool log 将显示到控制台上的内容出力到log文件里

spool on
--spool log 出力位置

spool C:\test.lst

WHENEVER SQLERROR EXIT 2 ROLLBACK
--非过程语句写到BEGIN END 之外
select * from aoan.testTBL;

DECLARE
    allKensu NUMBER;

--过程语句写到BEGIN END 块里
BEGIN
   select count(*) into allKensu from aoan.table1;

--
    DBMS_OUTPUT.PUT_LINE('count：' |