Thanks for the question.
Asked: March 12, 2001 - 7:09 am UTC
Last updated: March 13, 2001 - 1:35 pm UTC
Version: 7.3.4
Viewed 1000+ times
it shows how to dynamically create a flat file from any query using DBMS_SQL. Change the UTL_FILE calls to dbms_output and you have what you need. See also:
A reader, March 13, 2001 - 1:35 pm UTC
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library