SPOOL sql语句实现LOOP循环转储多文件

客户想在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