Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Stripping of spaces in SQL Plus
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.noReceived on Wed Mar 26 1997 - 00:00:00 CST
_____________________________________________________________