Re: Using DBMS_OUTPUT to output columns?

Without looking into other 'smarter' options, you could print a comma , in the output between the columns. Most tools can load a CSV without too many problems.

phersh wrote:
>
> 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 Tue Jul 04 2000 - 00:00:00 CDT