Export to a ascii, tab delimited file

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, Received on Tue Dec 01 1998 - 00:00:00 CST