Dynamic spool files

Dear Netters,

Seems that the question has been answered in the past, but for a single file...

What I am looking to do is to generate a set of spool files, where the file name is based on the table_name from user_tables.

So, in a nutshell, a script that would look like this:

FOR rec IN (SELECT table_name FROM user_tables LOOP
   spool rec.table_name
   <select some values to populate the file>    spool off
END LOOP; So, it is the spool file per entry in the user_tables, and it needs to be done on the client side, rather than the server.

Any ideas will be greatly appreciated!
Thank you in advance.

--Alex Received on Mon Mar 14 2005 - 15:19:13 CST