Re: Stripping of spaces in SQL Plus

On Wed, 26 Mar 1997 11:49:52 GMT, alf-ka_at_online.no (Alf-Kenneth Aabel) wrote:

I think there is a setting called SQLTRIM.

SQL> set sqltrim off

Other than that, we use a small Unix script to do it.

>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 Wed Mar 26 1997 - 00:00:00 CST