oracle merge into 语法

MERGE INTO upperLowerLimitData t1
USING (select name,enname,starttime,value ...   from dual) t2
ON (t1.name = t2.name and t1.enname = t2.enname)
WHEN MATCHED THEN
UPDATE SET t1.starttime = t2.starttime, t1.value = t2.value
WHEN NOT MATCHED THEN
INSERT (t1.name,t1.cid,t1.id,t1.aid,t1.starttime,t1.stoptime,t1.inttype,t1.interval,t1.enname,t1.value)
VALUES (t2.name,t2.cid,t2.id,t2.aid,t2.starttime,t2.stoptime,t2.inttype,t2.interval,t2.enname,t2.value)

posted on 2016-02-27 21:49  lui  阅读(418)  评论(0编辑  收藏  举报