Shell Programming and Scripting

$ cat s.txt
SQL> select sum(salary) from emp;

SUM(SALARY)
-----------
      30807

SQL> spool off

Jay@Jay-PC ~
$ grep  " *[0-9]" s.txt
      30807

c=`grep "[0-9]" s.txt`
echo "the value is $c"

$ cat x
#!/bin/ksh

( $ORACLE_HOME/bin/sqlplus -s login/password@database <<EOF
  set heading off;
  set pagesize 0;
  select 'count='||count(*)
  from dual;
  exit;
EOF
)|
while read line     # Read a line at a time.  Could get blank lines.
do
 if [[ -n $line ]]  # If the line read is not blank...
   then eval $line  # eval causes $line to be evaluated twice, thus
                    # setting shell variables with the data returned.

        ## Print out what was read in.  Quotes are needed around the
        ## variables so printf sees nulls.
        printf "%d\n" "$count"
 fi
done

exit 0
$ x
1
$