Shell Programming and Scripting

echo "Start"
export NUMROWS=`td "select * from dbc.database" 2> /dev/null | 
    grep "Query completed" | sed -e 's/.*Query completed. //g' -e 's/row.*found.*//g'` & 
WAITPID=$!
echo $NUMROWS
ps -ef | grep $WAITPID
wait $WAITPID
echo $NUMROWS

export NUMROWS=`td "select * from dbc.database" 2> /dev/null | 
    grep "Query completed" | sed -e 's/.*Query completed. //g' -e 's/row.*found.*//g'`

select count (*)

/tmp/td "select * from dbc.databases" 2> /dev/null | grep "Query completed" | sed -e 's/.*Query completed. //g' -e 's/row.*found.*//g' | awk ' { print "export NUMROWS=" $0 } ' > tmp_rpt &
WAIT_PID=$!
 
while [ "`ps -ef | grep ${WAIT_PID} | grep -v grep`" != "" ]
do
    sleep 10
done
 
. ./tmp_rpt
rm ./tmp_rpt
 
echo "1: " $NUMROWS

$ unset v
$ sqlplus -s / as sysdba<<-! |&
  set feed off pages 0
  exec dbms_lock.sleep(5);
  select sysdate from dual;
!> > > >
[1]     20027
$ read -p v
$
[1] +  Done    sqlplus -s / as sysdba<<-! |& ;  set feed off pages 0;  exec dbms_lock.sleep(5);;  select sysdate from dual;;!
$ echo "$v"
24-AUG-10

while [ "`jobs`" ]
do
        echo "still running"
        sleep 10
done