Re: Export into a textfile

From: Robert Malikian <robert_malikian_at_zdnet.com>
Date: Tue, 6 Feb 2001 11:59:02 -0000
Message-ID: <8JRf6.44$WE.656@news.uk.colt.net>

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!
>
Received on Tue Feb 06 2001 - 05:59:02 CST