setting the width of line in sql*plus

[Chrissirhc]

Hi when I do a select * from myTable I've got so many columns that it gets confusing.

How do I change the formating.

I think its something like set linesize = 500

but that doesn't work. I get the error

"SP2-0268: linesize option not a valid number"

from that.

 

[nme]

almost, use this:
SET LINESIZE 500

if you want to make the columns smaller use the column command.
e.g. to get a text field from 100 down to 20 you wuold type:
column my_column format a20