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_at_news.uk.colt.net>
Date: Tue, 6 Feb 2001 11:59:02 -0000
Message-ID: <8JRf6.44$WE.656_at_news.uk.colt.net>
It should be easy!
Starts a SQL session then
spool my_file
[Quoted] [Quoted] 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 - 12:59:02 CET