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

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

Re: Export into a textfile

From: Keshava M P <keshava_at_crosswinds.net>
Date: Sat, 14 Apr 2001 22:22:26 +0530
Message-ID: <3ad88028_1@excalibur.gbmtech.net>

Hi,
In addition to other's input, please note following: In addition to set serveroutput off and termout off, you need to set crt off.
There is a good tool to export to an excel file, from which you can save into many formats. try http://www.oraexcel.com regds,
"Dmitry" <support_at_ispirer.com> wrote in message news:9auojr$6qguu$1_at_ID-75577.news.dfncis.de...
> Hi,
>
> Also have a look at the text export tool Chyfo at
> http://www.ispirer.com.chyfo.html
>
> Best regards, Dmitry.
>
> "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 Sat Apr 14 2001 - 11:52:26 CDT

Original text of this message

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