Re: Dynamic spool files

Alex wrote:
> Mark,
>
> Can you give an example -- I am not sure I understand :(
>
> Thanks!

set serverout on
set pagesize 0
set echo off
set verify off
set feedback off
set heading off
set trimspool on
spool Yourscript.sql
FOR rec IN (SELECT table_name FROM user_tables LOOP
   dbms_output.put_line(rec.table_name || '.spl');

• This is the slave query that you generate which gets spooled to file dbms_output.put_line('select sysdate from dual;'); dbms_output.put_line('spool off'); END LOOP; spool off
  • Execute generated script @Yourscript.sql

Plsql block will result in Yourscript.sql that will look like this,

spool table_name1.spl
select sysdate from dual;
spool off
spool table_name2.spl
...
spool off

Regards
/Rauf Received on Tue Mar 15 2005 - 17:23:26 CST