Re: Export into a textfile

spool myoutfile.txt
...do some sql stuff here
spool off

you turn spooling off with the spool off command.

note that the entire SQL*Plus manual is on-line at http://otn.oracle.com if you need to look up SQL*Plus commands.

steve long
"The world's best technology strategist." (TM)

"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 - 00:41:54 CDT