Re: Exporting to a .csv file

Thanks alot, I will try it out............... Thanks for taking the tie to help mw out.
"Frank" <franjoe_at_frisurf.no> wrote in message news:JX4z6.4697$R6.102048_at_news1.oke.nextra.no...
> Hi!
> Try;
>
> set heading off
> 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 - 23:05:29 CEST