UNIX for Advanced & Expert Users

set timing on;
 
whenever sqlerror exit failure;
 
 
 
spool myscript.log append
 
 
accept start_date char prompt 'Enter start date ( DD-MON-YYYY ) : '
accept   end_date char prompt 'Enter end date ( DD-MON-YYYY ) : '
 
 
prompt start date: &start_date
prompt   end date: &end_date
 
 
PROMPT >> Inserting records into master
 
INSERT INTO master t
SELECT /*+ PARALLEL(t1,8) */ * FROM T1 t1 where date_col between '&start_date' and '&end_date';
commit;
 
undef start_date
undef  end_date
exit;

SELECT /*+ PARALLEL(t1,8) */ * FROM T1 t1 where date_col between ADD_MONTHS(TO_DATE('&start_date','DD-MON-YYYY'),(i-1)) and ADD_MONTHS(TO_DATE('&start_date','DD-MON-YYYY'),i);

#!/bin/bash

setDateParam() {
if [ ! -z "$2" ]
then
   echo "You can only pass in one parameter: -d, -w, -m, -y"
   exit 1
fi

export DATE_FLAG=$1
}


while getopts "dwmy" Option
do
   case $Option in
      d ) setDateParam "D"    "${DATE_FLAG}"  ;;
      w ) setDateParam "W"    "${DATE_FLAG}"  ;;
      m ) setDateParam "MM"   "${DATE_FLAG}"  ;;
      y ) setDateParam "YYYY" "${DATE_FLAG}"  ;;
      * )
         echo "You must pass in one parameter: -d, -w, -m, -y"
         exit 1 ;;
   esac
done

echo "DATE_FLAG: ${DATE_FLAG}"