Re: Sqlplus Auto-trim Whitespace???

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 us.

Jared

On Friday 05 April 2002 11:36, Walter K wrote:
> 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 saw the tip in a book a couple years ago and
> can't remember for the life of him how he went about
> it. I have poured through the docs myself and other
> references and can't seem to find a way to do this.
>
> The objective is to set the COLSEP to say '|' and then
> be able to perform something like a SELECT * FROM
> <table> such that the output/display is variable
> length for each column.
>
> The solution we're looking for is purely within
> SQL*Plus, not doing something with PL/SQL. Also, the
> solution should not involve using the COLUMN command
> to control the formatting of each column literally.
>
> Anyone know how to do this? Does anyone remember the
> tip and possibly the name of the book?
>
> Thanks again!
> -w
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Tax Center - online filing with TurboTax
> http://taxes.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).