merge 的语法,举个例子:
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;