Re: comma delimited

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Tue, 25 Jul 2006 21:05:27 GMT
Message-ID: <rIvxg.3299$K94.362@trnddc01>

Shredder wrote:
> I am forced to use a somewhat generic sql editor that does not allow me to
> save my output to a comma delimited file (CSV). Is there a way to include
> something, in my script, to generate this output with the commas in it?
>
>

sqlplus, and the concatenation operator.

set pages 0 feedback off
spool output.txt
select col1 || ',' || col2 || ',' || col3 from mytable
/
spool off
exit Received on Tue Jul 25 2006 - 16:05:27 CDT