Export to a ascii, tab delimited file
From: Fabian Bakker <fbakke_at_ctp.com>
Date: 1998/12/01
Message-ID: <3663D50D.6CDA57BA_at_ctp.com>#1/1
Date: 1998/12/01
Message-ID: <3663D50D.6CDA57BA_at_ctp.com>#1/1
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:
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, Received on Tue Dec 01 1998 - 00:00:00 CET