Re: SQL*Plus reporting question

Trying to get Oracle to output it's header line just the way you want is going to drive you crazy. Just add a prompt before the select to output the header line...

spool ...
prompt COLUMN 1,COLUMN 2,COLUMN 3
select ...

Richard

D Newsham wrote:
>
> Hi,
>
> I hope I am posting to the right group. If not please let me know as
> I don't like to cross-post.
>
> I have written a query to produce a csv file from SQL*Plus. I also
> need the headers to come out as a single line, comma separated. Can
> this be done?
>
> So far I have discovered that I can turn the headers off, make them
> come out in one single string, or be separated by space with an
> underline underneath. I really need the headers to come out in a
> single, comma separated line so my client can import it into Excel
> without having to type in all of the column headers.
>
> Here is what I have so far (actual file contains about 60 columns):
>
> set heading off pagesize 0 linesize 2000 feedback off
>
> spool testfile
> SELECT
>
> column_1||','||
> column_2||','||
> column_3||','||
>
> FROM test_table
> order by column_1,column_2,column_3
> /
> spool off
>
> Thanks!
> Dina
Received on Tue May 21 2002 - 14:04:31 CDT