Re: Export to a ascii, tab delimited file

Try "SET TRIMSPOOL ON"

On Tue, 05 Jan 1999 12:53:29 GMT, oracle_man_at_hotmail.com wrote:

>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

--
Chuck Hamilton
chuckh_at_safeaccess.net

Never share a foxhole with anyone braver than yourself!