UNIX for Advanced & Expert Users

${ORACLE_HOME}/bin/sqlplus -s ${loginid}/${password}@//${server}:${port}/${servicename} |&

while [[ $flag -eq 1 ]]
do
#obtain the $sql_stmt from a file here
print -p -- "${sql_stmt}"
# if it is select statement i use read -p to obtain the output
done
print -p -- exit

${ORACLE_HOME}/bin/sqlplus -s ${loginid}/${password}@//${ server}:${port}/${servicename} > ${connect_output} 2>&1 |&

SPOOL <logfilename1>
.... connnect sequence ...
SPOOL OFF

SPOOL <logfilename2>
... sql statements
SPOOL OFF

EXIT;