Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: formatting output with SQL*Plus

Re: formatting output with SQL*Plus

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Fri, 10 Dec 2004 10:44:08 +0000
Message-ID: <hKwdBda43XuBFwb7@jimsmith.demon.co.uk>


In message <31tc22F3f14lnU1_at_individual.net>, Thomas Kellerer <NNGNVRDSJEBN_at_spammotel.com> writes
>On 10.12.2004 11:24 Jim Smith wrote:
>
>> This (trimming columns in sqlplus) is a longstanding problem. Its very
>> annoying that Oracle haven't fixed it even after all this time.
>
>From the manuals I would have thought that "set trimspool on" should do exactly
>what I want, but obviously it doesn't...
>

IIRC, it only trims the trailing spaces at the end of the line.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Fri Dec 10 2004 - 04:44:08 CST

Original text of this message

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