how to increase width of sql plus output

[imsean]

hi guys, i am not used to working with sql plus, but have to on this machine where i can't install anything else. The problem is on SQL Plus the output width seems really less, as a result my rows get broken up and come below one another.

I went to options, environment and tried adjusting the buffer width but that doesn't seem to change anything, any idea guys?

[rajavu]

Try Using SET LINESIZE for increase the width of SQL PLUS OUTPUT

Or COLUMN FORMAT for formatting the column especially the size of each column.

[tyro]

hi use

SET NUMWIDTH [I]value[/I] - default width for Number columns
SET LONG [I]value[/I] - default width for LONG columns
SET LONGCHUNKSIZE [I]value[/I] - default width for LONG columns
SET MAXDATA [I]value[/I] - Max width for columns
 
[B]SET LINESIZE [I]value[/I] - Width of output[/B]

Cheers!

and