Shell Programming and Scripting

SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2;
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2;
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2;
SELECT COLUMN4 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN4 FROM SCDEMA2.TABLE2;

SELECT COLUMN1 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN1 FROM SCDEMA2.TABLE2; 0
SELECT COLUMN2 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN2 FROM SCDEMA2.TABLE2; 0
SELECT COLUMN3 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN3 FROM SCDEMA2.TABLE2; 0
SELECT COLUMN4 FROM SCHEMA2.TABLE1 MINUS SELECT COLUMN4 FROM SCDEMA2.TABLE2; 0

while read line; do
sqlplus $user/$pass << EOF >> $LOGDIR/$0.log
...
...
SET DEFINE OFF;
...
spool $SCRIPTDIR/result.txt
$line
spool off;
EXIT;
EOF
done < /ogc23788/scripts/sql_input.txt

 
02:34:04 SQL> SELECT 1+1 FROM DUAL;
       1+1
----------
         2
Elapsed: 00:00:00.01
02:34:04 SQL> spool off;

SET PAGESIZE 0
SET HEADING OFF
SET TIMING OFF

while read line
do
      sqlplus -S << EOF >> $0.log
      $user/$pass
      ...
      ...
      SET DEFINE OFF;
      ...
      spool /tmp/result.txt
      $line
      spool off;
      EXIT;
      EOF

      read value < /tmp/result.txt
      if [ "$value" = "no rows returned" ]
      then
         value=0
      fi

      print "$line $value"
      rm /tmp/results.txt
done < /ogc23788/scripts/sql_input.txt > $SCRIPTDIR/result.txt

#!/...
output=$PATH/output.txt
...
echo "QUERY|RESULT"> $output
while read line; do
count=$(sqlplus -s $user/$pass << EOS
set heading off
set feedback off
whenever sqlerror exit 1
SELECT COUNT(*) FROM ($line);
quit;
EOS)
echo "$query|$count" >> $output
done < /path/input_queries.txt