SQL Plus and variable linesize in spool file 2

[petersJazz]

hi,

is it possible to set sqlplus to have variable line size.

Example:

spool /export/xyz.dat
linesize ?
select trim(col1) || ';' || trim(col2)
from table
where condition = 0;
spool off

 

[sem]

You should set linesize to the highest expected value and then add set trimspool on

Regards, Dima

http://seminihin.narod.ru