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" &
Shell函数 传递多个参数
最新推荐文章于 2024-06-11 18:23:15 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)