Shell Programming and Scripting

#!/usr/bin/ksh

main() 
{
   resultset=`sqlplus -s ${DB_LOGIN}@${DB} << SQLEND

   select * from table_user;

SQLEND`

}

#!/usr/bin/ksh
main()
{
   sqlplus -s ${DB_LOGIN}@${DB} > table_user.txt <<SQLEND
    set feed off
     set head off
     set pages 0
     set verify off
   select * from table_user;
SQLEND

while read line
do
echo $line
done < table_user.txt
}

#  the command returns COUNT=<nbr> which is then eval'd to set a variable.
eval $(print "select 'COUNT='||count(*) as count from <schema>.<table>;
"|sqlplus -s / |grep COUNT=)

print "The count is $COUNT"

efs:/home2/myid $ test.ksh
The count is 79931
efs:/home2/myid$

# Read results a line at a time
cat $sqlresults | while read line
do
   # Process each line of SQL output.
   echo $line
done