Hi,
It will work only when data don't contain commas.
www.ispirer.com/chyfo.html for a tool that goes around this problem.
--
Best regards, Dmitry
In article <8JRf6.44$WE.656_at_news.uk.colt.net>,
"Robert Malikian" <robert_malikian_at_zdnet.com> wrote:
> It should be easy!
> Starts a SQL session then
> spool my_file
> SELECT field1||','||field2||','||.... FROM the_table;
> spool off
>
> Robert
> "Alexandru R. Taranu" <alexandru.r.taranu_at_constud.de> wrote in message
> news:3A7FE245.DD306FBF_at_constud.de...
> > Hi,
> >
> > I would like to export some data from a table into a columns-
separated
> > textfile. The Oracle-Datamanager provides only import, export and
> > load-functions. There is no "unload"-function available.
> > Can anybody help?
> >
> > Thanks!
> >
>
>
Sent via Deja.com
http://www.deja.com/
Received on Wed Feb 07 2001 - 08:20:49 CST
