Re: Export to a ascii, tab delimited file

Using TOAD, you can export any table or the results of any query into a tab delimited file or to clipboard. And it does a whole lot of other things for Oracle developers so it isn't a one-shot utility.

It's at www.toadsoft.com

> You may want to have a look at Oraxcel, my Oracle to MS Excel utility. You
> simply send the SQL to Oracle and receive the data straight into your
> spreadsheet. Use Excel's features after that to save it in any format you
> like...
>
> Oraxcel can be gotten from http://members.aol.com/gjlinker
>
> If you're just interested in fetching data from Excel the free LITE version of
> Oraxcel is all you need.
>
> Regards, Gerrit-Jan Linker
>
> In article <3663D50D.6CDA57BA_at_ctp.com>,
> Fabian Bakker <fbakke_at_ctp.com> wrote:
> > Hi,
> >
> > I want to export data to a ascii, tab delimited file. The linesize is
> > set to 2000, because the final select statement will have lots more
> > columns.
> >
> > Now I use the following sql script:
> > SET LINESIZE 2000;
> > SPOOL C:\OUTPUT.TXT;
> > SELECT
> > RTRIM(OWNER||CHR(9)||TABLE_NAME||CHR(9)||TABLESPACE_NAME||CHR(9)||RTRIM
 (CLUSTER_NAME))
> >
> > FROM SYS.ALL_TABLES;
> > SPOOL OFF;
> >
> > The problem with this script is that their are numerous spaces at the
> > back of each line, Those trailing spaces must be trimmed. I don't know
> > how to do that.
> >
> > Thanx in advance,
> >
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Jan 05 1999 - 00:00:00 CST