Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: generate CSV
To get a csv file from a table
"Paul Brewer" <paul_at_paul.brewers.org.uk> a écrit dans le message de news:
3c9cc154_3_at_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 Sun Mar 24 2002 - 06:44:28 CST