Re: Exporting to a .csv file

Hi!
Try;

set heading off
[Quoted] set colsep ","

spool c:/temp/myresult.csv
SELECT ......... spool off

This will give comma separated columns, the drawback is that you get a lot of unnecessary spaces in the output.

Another potentially very tedious solution is

SELECT col1||','||col1||','||col3||','.....

Frank

Jeff Boyer <jdboyer_at_(remove)icomproductions.ca> wrote in message news:9aijh7$mej$1_at_news3.cadvision.com...
> Hello everyone,
>
> Can anyone tell me how to Export my database to a comma separated value
> file. I have done some reading on the net about this but everywhere I go
> they say you need to spool from within SQL*Plus with a custom script, but
> there are no examples of this custom script. Can anyone help me?
>
> Thanks,
> Jeff
>
>
Received on Thu Apr 05 2001 - 22:53:50 CEST