Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Exporting to a .csv file

Re: Exporting to a .csv file

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 5 Apr 2001 22:48:21 +0200
Message-ID: <tcpsvknvto37c0@beta-news.demon.nl>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US