Re: Export to a ascii, tab delimited file

set trimspool on

Fabian Bakker 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,
  Received on Thu Dec 10 1998 - 00:00:00 CET