Oracle dynamic spool.

Hi guys,

Hey, I wanted to see if anybody out there had a script that dynamically creates a spool file for delimited data for all tables for a user.

For example, we have a user that we would like to spool to comma-delimited format, but being that there is 500+ tables, the select "select column01 ||','||from mytable" method would be tedious since we'd have to do it for each table.

Does anybody have a scirpt that dynamically spools all tables for a particular user? Thanks. We are on Oracle 8174, HP-UX 11. Or if there is a better way, that would also be helpful.

Thanks again. Received on Thu May 15 2003 - 12:56:45 CDT