Using DBMS_OUTPUT to output columns?

Hi,

How do I use DBMS_OUPUT to return what looks like standard columns to a generic desktop query tool.

In other words, when I issue a standard 'SELECT * FROM Foo', the results returned are usually placed into a spreadsheet like display by most query tools. When I return output using PUT or PUT_LINE, the values I'm returning for each row are concatenated into one long text string. How do I format the output so those values are recognized as separate data columns by a desktop query tool?

Thanks,
Phil

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Jul 03 2000 - 00:00:00 CDT