SQL*Plus reporting question

From: D Newsham <d_newsham_at_hotmail.com>
Date: 21 May 2002 11:08:22 -0700
Message-ID: <c883e8dd.0205211008.3b605ef1@posting.google.com>

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 - 13:08:22 CDT