代码改变世界

connect DB

2016-11-18 11:46  雄风狂飙  阅读(114)  评论(0)    收藏  举报 
sqlplus -s ${ACT_DBUSERID}/${ACT_PASSWD}@${ACT_DB} <<EOF
insert into tl_c_syscheck_log (ID, GROUP_ID, HOST, CHECK_POINT, STATE, CHECKRESULT, CHECKSTAFF, CHECK_DATE, AUDITOR, AUDIT_DATE, STR1, STR2, STR3, STR4, STR5)
values (to_number(to_char(sysdate,'yyyymmddhh24miss')), '01', '130.87.7.86', '001', '0', '1', '66587', sysdate, '', null, '', '', '', '', '');
 commit;
EOF