Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Stripping of spaces in SQL Plus

Re: Stripping of spaces in SQL Plus

From: Mikhail Rezhepp <mrezhepp_at_best.com>
Date: 1997/03/27
Message-ID: <333A07B8.633E@best.com>#1/1

Alf-Kenneth Aabel wrote:
>
> 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
> _____________________________________________________________
You may want to use DBMS_OUTPUT package. I's much more flexible way to write to a file then spooling from SQL*Plus. See Oracle7.3 Server Developers Guide.
BR
Mikhail Rezhepp Received on Thu Mar 27 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US