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 -> Re: SQL*Plus question. Trimming column lengths.

Re: SQL*Plus question. Trimming column lengths.

From: Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl>
Date: Wed, 13 Feb 2002 10:53:13 GMT
Message-ID: <3c6a450f.909143@news.freeler.nl>


At the start of your career spanning years you couldn't have noticed because trimspool was only available starting from 7.3...

Jaap.

On Wed, 13 Feb 2002 10:36:32 +1100, "Ray Teale" <ray_at_BLAHholly.com.au> wrote:

>set trimspool on - that was it!!!.
>
>I'm astonished that in all those years of SQL*Plus report writing and I'd
>never noticed that one before.
>
>You learn something everyday.
>
>Thanks.
>
>Ray
>
>
>"Geoff Reader" <grr_at_NOSPAM.bton.ac.uk> wrote in message
>news:3C6940D3.17231C8E_at_NOSPAM.bton.ac.uk...
>>
>> Or maybe just make teh line much longer and use:
>> set trimspool on
>>
>> Geoff
>> University of Brighton
>
>
Received on Wed Feb 13 2002 - 04:53:13 CST

Original text of this message

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