Stripping of spaces in SQL Plus
From: Alf-Kenneth Aabel <alf-ka_at_online.no>
Date: 1997/03/26
Message-ID: <5hb2g7$glb$1_at_bone.global-one.no>#1/1
Date: 1997/03/26
Message-ID: <5hb2g7$glb$1_at_bone.global-one.no>#1/1
Hi.
[Quoted] [Quoted] I'm wondering if anyone know how to strip trailing whitespaces from a SELECT statement.
Eg.
[Quoted] [Quoted] 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.noReceived on Wed Mar 26 1997 - 00:00:00 CET
_____________________________________________________________