UNIX for Dummies Questions & Answers

MIN_BATCH=`sqlplus -s user/pw@sid<<eof
	set serveroutput on;
	set feedback off;
	set linesize 1000;
	SELECT to_char(Min(IF_ROW_BATCH_NUM),'999999999999999')MIN FROM SIEBEL.EIM_SRV_REQ WHERE IF_ROW_STAT = 'FOR RECUR IMPORT';
	`
	min="${MIN_BATCH#"${MIN_BATCH%%[[:digit:]]*}"}"   # strip off non-digit prefix from str ...........................................................................

sqlplus -s user/pw@sid > /tmp/$$ <<eof 
	set serveroutput on;
	set feedback off;
	set linesize 1000;
	SELECT * FROM table;
EOF

while read LINE
do
       ...
done < /tmp/$$

rm -f /tmp/$$

sqlplus -s user/pw@sid < script.sql | while read LINE
do
        ...
done

set pagesize 0;
set heading off;