oracle merge into 语法 10g,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)

原文：http://www.cnblogs.com/lj821022/p/5223665.html