v_par_date='2014-12-31'
dlt_table() {
sqlplus dwm/dwm@dwh1<<!
delete from $1.$2 where set_date=date'$3';
commit;
exit
!
}
dlt_table dwm "M_COMC_SUBJ_CODE_TRAN_PARA_H" "$v_par_date" &
dlt_table dwf "F_FI_ACCR_REPORT_BOOK" "$v_par_date" &