I have a question about spooling the the results of my program. My sample sql script looks like this.
whenever sqlerror exit failure rollbacksetheadingoffset arraysize 1set newpage 0set pages 0set feedback offset echo offsetverifyoffdeclare
ab varchar2(10) := 'Raj';
cd varchar2(10);
a number := 10;
c number;
d number;
beginc := a+10;
select ab,cinto cd,dfrom dual;
end;
SPOOL
select cd,dfrom dual;
SPOOL OFF
EXIT;
上面的脚本不起作用，但我想做这样的事情，在开始结束块中我们计算一些值，我想假脱机这些结果.
The above script does not work, but I want to do something like this where in the begin end block we compute some values and i want to spool those results.
This will spool the output from the anonymous block into a file called output_<YYYYMMDD>.txt located in the root of the local PC C: drive where <YYYYMMDD> is the current date:
SET SERVEROUTPUT ONFORMATWRAPPEDSETVERIFYOFFSET FEEDBACK OFFSET TERMOUT OFFcolumn date_column new_value today_var
select to_char(sysdate, 'yyyymmdd') date_column
from dual
/
DBMS_OUTPUT.ENABLE(1000000);
SPOOL C:output_&today_var..txt
DECLARE
ab varchar2(10) := 'Raj';
cd varchar2(10);
a number := 10;
c number;
d number;
BEGINc := a+10;
--SELECT ab, cINTO cd, dFROM dual;
--
DBMS_OUTPUT.put_line('cd: '||cd);
DBMS_OUTPUT.put_line('d: '||d);
END;
SPOOL OFF
SET TERMOUT ONSET FEEDBACK ONSETVERIFYONPROMPTPROMPT Done, please see fileC:output_&today_var..txt
PROMPT
After your comment to output a value for every iteration of a cursor (I realise each value will be the same in this example but you should get the gist of what i'm doing):
BEGINc := a+10;
--
FOR i IN 1 .. 10
LOOP
c := a+10;
-- Output the value of C
DBMS_OUTPUT.put_line('c: '||c);
ENDLOOP;
--END;
