Red Hat

#!/bin/bash
val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select max(stat_id) from cvt_stats;
exit
EOF
)
nohup ./cvt -f MediationSources.xml &
sleep 60
val_2=$( sqlplus -s rte/rted2@rel76d2 << EOF
setting heading off
select source_id from cvt_istats where istat_id > val_1;
exit
EOF
)

#!/bin/bash
val_1=$( sqlplus -s rte/rted1@rel75d1 << EOF
setting heading off
select max(stat_id) from cvt_stats;
insert into mukti(stat_id) values( $val_1 );
exit
EOF
)
echo  "val_1: $val_1"
nohup ./cvt -f MediationSources.xml &
sleep 60
val_2=$( sqlplus -s rte/rted1@rel75d1 << EOF
setting heading off
select source_id from cvt_istats where istat_id > (select stat_id from mukti);
exit
EOF
)
echo  "val_2: $val_2"