you can inclue set linesize command.


SQL> set linesize 1000

then run you select command.


thnx

P. Soni