Hi all,
Please help me with the issue im facing.
my client has a recquirement that unix script has to schedule the no.of jobs based on the value from the oracle table.for example if the table has a value of 20 the unix script has to schedule 20 jobs.im able to write the script to get the value frm the oracle table and from here im not able to make out how to proceed..please help me in this regard..please find the code i have written and help me in extending this script .
#!/bin/sh
var1=`sqlplus -s scott/tiger <<EOF
set head off;
select <column> from table;
exit;
EOF`
echo $var1