Shell Programming and Scripting

 
for i in `ls`
do
nohup sqlldr userid=apps/apps data=data01.dat log=my1.log control=my.ctl bad=my1.bad direct=yes silent=all parallel=true &
done

for i in `ls`
do
nohup sqlldr userid=apps/apps data=data01.dat log=my1.log control=my.ctl bad=my1.bad direct=yes silent=all parallel=true &
Process_ID=$!
echo "${Process_ID}" >> file.out
done

SELECT process FROM v$session WHERE username = 'SCOTT';

wait ${Process_ID}

if [[ $(ps -eaf | awk -v pid="${Process_ID}" '$2 == pid {} END {print NR}') > 0 ]]; then
echo "Running";
else
echo "Completed";
fi

#!/bin/bash

sqlplus -s apps/apps << EOF
whenever sqlerror exit sql.sqlcode;
set echo off
set heading off
delete from tablename;
exit;
EOF


for i in `ls`
do
nohup sqlldr userid=apps/apps data=data01.dat log=my1.log control=my.ctl bad=my1.bad direct=yes silent=all parallel=true &
Process_ID=$!

sqlplus -s apps/apps << EOF
whenever sqlerror exit sql.sqlcode;
set echo off
set heading off
insert into tablename (id,status) values ($Process_ID,'Running');
exit;
EOF

done

RunningProcess {

count=$(sqlplus -s apps/apps << EOF
whenever sqlerror exit sql.sqlcode;
set echo off
set heading off
select count(id) from tablename where status='Running';
exit;
EOF)

}

RunningProcess;
while [ $count -gt 0 ]
do

echo "
whenever sqlerror exit sql.sqlcode;
set echo off
set heading off
select id from tablename where status='Running';
" |sqlplus -s apps/apps | while read Pid
do
      ps -f $Pid 2>/dev/null
      if [ $? -eq 1 ]
      then
          sqlplus -s apps/apps << EOF
          whenever sqlerror exit sql.sqlcode;
          set echo off
          set heading off
          update tablename set status='Completed' where id=$Pid;
          exit;
          EOF
      fi
  done
  RunningProcess;
done