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

客户想在sql文件的spool中实现循环，每次循环为每天生成一个结果文件，在Oracle community 中找到如下方式记录：

SET serverout onSET some_more_appropriate_headingsSPOOL my_master_spool_fileBEGIN   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_fileHOST rm (or del)  my_master_spool_file

BY：https://community.oracle.com/message/1740638#1740638