MERGE语法
示例
MERGE INTO AMARE.T_USERLIST u USING (SELECT to_char(ptime,''yyyy-mm-dd hh24:mi:ss'') ptime,USER#,NAME FROM sys.user$ WHERE NAME='TESTUSER' ORDER BY USER#)
ON (l.name= u.username)
WHEN MATCHED THEN --已有记录则更新
UPDATE SET u.passwd=l.ptime,u.userid=l.user#
WHEN NOT MATCHED THEN --无记录则插入
INSERT(u.userid,u.username,u.passwd) VALUES(l.user#,l.name,l.ptime)