读书人

merge 对表新增也许修改

发布时间: 2012-08-28 12:37:01 作者: rapoo

merge 对表新增或者修改

merge into ITIL_REPORT_DEVICE rd
using (select 1 from dual)
on (rd.id = '3d42e973-470a-48b8-ae01-729b417461e6')
when matched then
update set rd.reportName = 'kaka'
when not matched then
insert values ('666', 'name', sysdate, 'id_admin', '2', 'sss', '1', '');

读书人网 >其他数据库

热点推荐