Re: Export into a textfile

From: Bart <Bart_at_opcomp.demon.co.uk>
Date: Mon, 9 Apr 2001 23:16:33 +0100
Message-ID: <986854976.1037.0.nnrp-14.9e985e86_at_news.demon.co.uk>


"set termout off" has to be in an SQL file (or a so called HERE file), you can't just type it at the SQL prompt as it'll do nothing. "Greg Teets" <gteets_at_rr.cinci.com> wrote in message news:3ad0ed09.698570751_at_news-server...
> When i spool to a file, how can i turn off the screen output in
> Windows?
>
> Thanks for your help.
>
>
> On Tue, 6 Feb 2001 11:59:02 -0000, "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!
> >>
> >
> >
>
Received on Tue Apr 10 2001 - 00:16:33 CEST

Original text of this message