Re: Export into a textfile

set termout off
spool etc
select etc
spool off
set termout on

setting echo/on/off just controls the echoing of your command itself, not the result.

"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 Mon Apr 09 2001 - 15:37:17 CEST