oracle - merge 一例

  

merge 的语法，举个例子：

begin
    merge into emp_t t
    using (select * from emp_s) s
    on ( t.empid=s.empid   )
    when matched then
      update set t.empnm=s.empnm
    when not matched then
      insert  (empid,empnm,deptnm,create_time,modify_time,action_flag)
        values (s.empid, s.empnm, s.deptnm, s.create_time, s.modify_time,'0' )
    ;
    commit;
end;