54.iBATIS, MyBatis/iBatis2012. 3. 5. 19:51
반응형

DECLARE
    BEGIN
     UPDATE table_a SET 
            mdf_dt = SYSDATE
      WHERE  gds_ctf_no = #gds_ctf_no#
    ;
     UPDATE table_b SET 
            mdf_dt = SYSDATE
      WHERE  gds_ctf_no = #gds_ctf_no#
    ;
    END; 
Posted by 1010