try SET TRIMSPOOL ON option
--
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX
Alf-Kenneth Aabel <alf-ka_at_online.no> wrote in article
<5hb2g7$glb$1_at_bone.global-one.no>...
> Hi.
>
> I'm wondering if anyone know how to strip trailing whitespaces from a
> SELECT statement.
>
> Eg.
> SELECT RTRIM(owner || ' - ' || table_name) FROM all_tables;
>
> results in
>
> RTRIM(OWNER||'-'||TABLE_NAME)
> ---------------------------------------------------------------
> SYS - DUAL
> SYS - SYSTEM_PRIVILEGE_MAP
> SYS - TABLE_PRIVILEGE_MAP
> SYS - STMT_AUDIT_OPTION_MAP
> SYS - AUDIT_ACTIONS
>
> The problem is that these lines are padded with spaces when spooled to
> a file. I want them to be variable length rows with no trailing
> spaces. Anybody know how this can be done in Server Manager or
> SQLPlus? All help would be appreciated.
>
> Alf-Kenneth
>
>
> _____________________________________________________________
> Name: Alf-Kenneth Aabel
> Title: Senior Software Engineer
> Company name: PRIDE AS
> Address: Wdm. Thranesgt. 77
> 0175 OSLO
>
> Ph work: +47 22 20 12 50
> Fax: +47 22 20 70 39
> Pager: +47 965 41021
> Email: alf.kenneth.aabel_at_pride.no
> _____________________________________________________________
>
>
>
Received on Thu Mar 27 1997 - 00:00:00 CST
