Oracle中merge into的使用

来源:互联网 发布:淘宝开过店可以再开吗 编辑:程序博客网 时间:2024/05/21 08:43




MERGE INTO BB BUSING (SELECT * FROM AA) AON(A.ID = B.ID)WHEN MATCHED THEN       UPDATE SET B.BLUE_BALL1 = A.BLUE_BALL1 WHERE A.ID = B.IDWHEN NOT MATCHED THEN         INSERT VALUES(A.ID,A.BLUE_BALL1);  


0 0
原创粉丝点击