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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
