merge into

create or replace procedure xsxxgl_test_2 is
begin
  merge into xsxxgl_xsjbxx_test a
  using (SELECT '20120168230' as xh, '于晴' as xm, '1111' as sfzjh FROM dual) b
  on (a.xh = b.xh)
  when matched then
    update set a.sfzjh = b.sfzjh
  when not matched then
    insert (a.xh, a.xm, a.sfzjh) values (b.xh, b.xm, b.sfzjh);
    commit;--记得提交
end xsxxgl_test_2;

 

Merge：更新插入，也就是说，如果表中已经有了指定列值的记录行，就执行一个更新行操作。如果没有指定列值的记录，就执行一个插入操作。