Re: SQL*Plus report format layout

Adjust the linesize ( as in set linesize 107 in beginning of script) to about 107 max for courier new 9 pt portrait or roughly 135 max for landscape. If linesize is already at max for your font size then you will have to adjust the columns individually to fit the data.

xo55ox_at_hotmail.com wrote:

> Hi,
>
> I have a question related to the report format layout which data is
> generated through SQL*Plus .
>
> I am trying to run a query and display the data from SQL*Plus. To make
> it more informative, I set the heading on, page 100 and pagesize 60.
> Which parameter should I change in order to make all columns displayed
> on one line since currently the last column is wrapped around onto the
> second line?
>
> Thanks in advance for any help!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Dec 06 1999 - 14:49:50 CST