Shell Programming and Scripting

bash-3.2$ /usr/sbin/lsof | grep '/tmp' | grep '(deleted)'
sh_test 13107     test    0u      REG    8,3      224   1782884 /tmp/sfe7h.34p (deleted)
sh_test 13107     test    1u      REG    8,3        0   1782887 /tmp/sffak.tri (deleted)

#!/bin/ksh
get_app_status(){
result=`sqlplus -s user/password@servicename <<EOF
whenever sqlerror exit sql.sqlcode
set escape off
set head off
set verify off
set feedback off
select param_value from status where param_name='app_status'
EOF
`
echo $result
}

while [ `get_app_status` = 'Started' ]; do
#Some logic here
done

exec > /tmp/newfile

#!/bin/ksh
get_app_status(){
eval `result=`sqlplus -s user/password@servicename <<EOF
whenever sqlerror exit sql.sqlcode
set escape off
set head off
set verify off
set feedback off
select param_value from status where param_name='app_status'
EOF
`
`
echo $result
}

while [ `get_app_status` = 'Started' ]; do
#Some logic here
done