nawk '{{print $1,$2,$3}}'  ./$DirectoryName/AuditGroupTableTableData_$TimeStamp.txt | while read a b c
do
  echo $a
  echo $b 
  echo $c
  ret=`sqlplus -s $db_user/$db_pwd@$db_sid  $a $b $c <<EOF > ./${DirectoryName}/Query.sql
SET HEADING OFF
SET SERVEROUTPUT ON
SET FEEDBACK OFF
DECLARE
CNT  NUMBER(5);
DROPCNT NUMBER(5);
ERRORCNT NUMBER(5);
BEGIN
  SELECT COUNT(*) INTO CNT FROM USAGE_INTRNL_ERROR WHERE AUDIT_GROUP_ID='&1';
  IF ( CNT != &3) THEN
    Dbms_Output.put_line('SELECT INTRL_DROP_QTY,INTRL_ERROR_QTY, ERRORCNT FROM USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_ID=''&1'';';
    SELECT INTRL_ERROR_QTY INTO DROPCNT FROM USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_ID = '&1';
    SET DROPCNT=DROPCNT-CNT;
    Dbms_Output.put_line('UPDATE USAGE_AUDIT_GROUP SET INTRL_DROP_QTY='||DROPCNT||' ,INTRL_ERROR_QTY='||CNT||'  WHERE USAGE_AUDIT_GROUP WHERE AUDIT_GROUP_ID=''&1'';'
  END IF;
END;
/
EXIT;
EOF`
  touch ./$DirectoryName/SELECTQuery_$TimeStamp.sql
  touch ./$DirectoryName/UPDATEQuery_$TimeStamp.sql
  for stmt in `cat ./${DirectoryName}/Query.sql`
  do
    is_select=`echo ${stmt} | grep "^SELECT" | wc -l`
    if [ ${is_select} -ne 0 ]
    then
      echo ${stmt} >> ./$DirectoryName/SELECTQuery_$TimeStamp.sql
    else
      echo ${stmt} >> ./$DirectoryName/UPDATEQuery_$TimeStamp.sql
    fi
  done
done