Re: Export into a textfile

Greg Teets wrote:

> 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!
> >>
> >
> >I think the command is a set command "set echo off". Give it a try.

Bart Sexton Received on Sun Apr 08 2001 - 18:12:55 CDT