客户想在sql文件的spool中实现循环,每次循环为每天生成一个结果文件,在Oracle community 中找到如下方式记录:
SET serverout on
SET some_more_appropriate_headings
SPOOL my_master_spool_file
BEGIN
FOR i IN 1 .. 10
LOOP
DBMS_OUTPUT.put_line ('Spool file' || i);
DBMS_OUTPUT.put_line ('Select * from table' || i || ';');
DBMS_OUTPUT.put_line ('Spool off');
END LOOP;
END;
SPOOL off
@my_master_spool_file
HOST rm (or del) my_master_spool_file
BY:https://community.oracle.com/message/1740638#1740638