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 -> Stripping of spaces in SQL Plus

Stripping of spaces in SQL Plus

From: Alf-Kenneth Aabel <alf-ka_at_online.no>
Date: 1997/03/26
Message-ID: <5hb2g7$glb$1@bone.global-one.no>#1/1

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

Original text of this message

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