sql script:


sqlplus -s /nolog << ENDSQL
connect user/password@inst;
set pagesize 0;
set feedback off;
set echo off;
set verify off;
set linesize 100;
spool txtfile;
set trimspool on;
select statement;
spool off;
ENDSQL