Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: generate CSV
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