Re: Export into a textfile

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 7 Feb 2001 17:11:17 +0100
Message-ID: <Zweg6.8936$lS6.159098@news1.oke.nextra.no>

Hi!

Or from SQLplus
set colsep ','
select * from the_table;

Frank

Robert Malikian <robert_malikian_at_zdnet.com> wrote in message news:8JRf6.44$WE.656_at_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 Wed Feb 07 2001 - 10:11:17 CST