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

Home -> Community -> Usenet -> c.d.o.server -> Re: generate CSV

Re: generate CSV

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Sat, 23 Mar 2002 17:50:17 -0000
Message-ID: <3c9cc154_3@mk-nntp-1.news.uk.worldonline.com>


Sybrand has answered your question, so I won't duplicate. Out of interest though, what is it you are trying to achieve? There may be easier ways.

Paul

"Titi" <thierry.constant2_at_wanadoo.fr> wrote in message news:3c9c5386$0$23203$626a54ce_at_news.free.fr...
> Hi,
>
> simple SQL question for you:
> how can I generate a csv file from a table in oracle ?
>
> something like:
> set head off
> set feed off
> select col1||';',col2||';'... from table_name ;
>
> the columns are in several lines , not one line
> I have problem with col format I think
>
> How can I do that ??
>
> Thanks
>
>
>
>
Received on Sat Mar 23 2002 - 11:50:17 CST

Original text of this message

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