Re: SQL*Plus question. Trimming column lengths.

From: Ray Teale <ray_at_BLAHholly.com.au>
Date: Wed, 13 Feb 2002 10:36:32 +1100
Message-ID: <WFha8.17830$N31.899266@ozemail.com.au>

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 Tue Feb 12 2002 - 17:36:32 CST

This message: [ Message body ]
Next message: Ted Chyn: "way to hard parsed sql in sharepool"
Previous message: Sathish Balas: "make file for pro*c"
In reply to: Geoff Reader: "Re: SQL*Plus question. Trimming column lengths."
Next in thread: Jaap W. van Dijk: "Re: SQL*Plus question. Trimming column lengths."
Reply: Jaap W. van Dijk: "Re: SQL*Plus question. Trimming column lengths."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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