SET TRIMSPOOL ON
-Original Message-
Sent: Friday, April 05, 2002 2:37 PM
To: Multiple recipients of list ORACLE-L
Hi,
A co-worker of mine is trying to remember how to have
trailing whitespace automatically removed from each
COLUMN in the output of a query within SQL*Plus. He
said he
Try either set trimout on
or set trimspool on
The first one affects screen output, the second one takes care of spooled output.
Rodd
On Fri, 2002-04-05 at 13:36, Walter K wrote:
Hi,
A co-worker of mine is trying to remember how to have
trailing whitespace automatically removed
Walter,
set trimspool ON (or set trimsp on or set trims on)
you can also use show all at the sqlplus prompt to get an idea about what
other options have been set (if you don't remember the command).
Margaret
-Original Message-
From: Walter K [mailto:[EMAIL PROTECTED]]
Sent: Friday,
Thanks for the suggestion. Unfortunately, trimspool is
only at the record level, not the column level. Same
with trimout.
I'm looking for variable column widths without having
to format each column or go through the hassle of a
long select statement with concatenations.
-w
--- Murray, Margaret
Walt,
I've tried to do this before, and could never come up
with a method other than generating SQL that looks
like:
select rtrim(col1), rtrim(col2), ...
from my_table;
No too hard to automate with a stored procedure
and dynamic SQL.
If you find a better way, be sure to share it with