Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Export into a textfile

Re: Export into a textfile

From: Greg Teets <gteets_at_rr.cinci.com>
Date: Sun, 08 Apr 2001 22:55:15 GMT
Message-ID: <3ad0ed09.698570751@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 Sun Apr 08 2001 - 17:55:15 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US