Thanks for the question.
Asked: March 12, 2001 - 7:09 am UTC
Last updated: March 13, 2001 - 1:35 pm UTC
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.
A reader, March 13, 2001 - 1:35 pm UTC
Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.
More on PL/SQL routine DBMS_SQL here