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