Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Exporting to a .csv file
"Jeff Boyer" <jdboyer@(remove)icomproductions.ca> wrote in message
news:9aijgi$meb$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
>
>
set underline off colsep '-' newpage none feedback off
before any select
will do the tric.
Hth,
Sybrand Bakker, Oracle DBA
Received on Thu Apr 05 2001 - 15:48:21 CDT