oracle中merge into用法格式

一般格式：

MERGE INTO [target-table] A USING [source-table sql] B ON([conditional expression] and [...]...)
WHEN MATCHED THEN
	[UPDATE sql]
WHEN NOT MATCHED THEN
	[INSERT sql]

作用:判断Ｂ表和Ａ表是否满足ON中条件，如果满足则用B表去更新A表，如果不满足，则将B表数据插入A表
实例：

MERGE INTO USER_INFO_TABLE A USING (SELECT T.NAME,T.SEX,T.AGE FROM  MAN_TABLE T) B ON(A.NAME=B.NAME)
WHEN MATCHED THEN
	UPDATE 
	SET A.NAME=B.NAME,
		A.SEX=B.SEX,
		A.AGE=B.AGE
WHEN NOT MATCHED THEN
	INSERT INTO (A.NAME,A.SEX,A.AGE) VALUES (B.NAME,B.SEX,B.AGE);
	COMMIT;