Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Export to a ascii, tab delimited file
Hi Fabian,
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 Received on Sun Dec 27 1998 - 00:00:00 CST