#!/usr/bin/sh
e_id=`sqlplus -s scott/tiger@DB<<eof
            SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF;
            select emp_id from employee;
            quit
            `
echo "Employee ID's $e_id"

group=GROUP1
# Getting the sss_no for each emp_id

for i in $e_id 
 do
   sss_nos=`sqlplus -s scott/tiger@DB <<eof
          SET PAGES 0 LINES 500 HEAD OFF;
          select sss_no from employee_bank where emp_id = $i;
          quit
          `
   echo "List of SSS no's $sss_nos"
   # Run a customize program that calls the sss_nos
   # SSS_move
   SSS_move $sss_nos $group
  sleep 2
done

#!/usr/bin/ksh
# Getting the sss_no for each emp_id
sqlplus -s scott/tiger@ORCL <<EOF >sss_nos
SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF
SELECT 'SSS_Move ' || sss_no || ' GROUP' || ROUND ((ROWNUM) / 2, 0)
      ||CHR(10)||'sleep 2'
  FROM emp, emp_bank
 WHERE emp_bank.employee_id = emp.employee_id
/
quit
EOF
echo "List of SSS no's:"
cat sss_nos
# Run the customize program that calls the sss_nos
# SSS_move:
. sss_nos