sqlplus output without line wrapping 1

[sapatos]

Probably an easy one, but I've not managed to find out how to do this.

sqlplus user/pw@db<<SCRIPT

select * from v$parameter;
SCRIPT

for example. outputs horribly due to screen wrapping. Is there any way I can pipe this to a file and open in an editor that allows me to display off the screen.

 

[SantaMufasa]

Sapatos,

Prior to your SQL SELECT statement in the script, place these two SQL*Plus commands:

set linesize 500
set trimspool on

Voilà...no more wrapping...and no superfluous right padding.


Let us know how it works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]