文章教程

oracle中merge into用法及实例解析

5/9/2018 10:33:01 PM 人评论 次浏览

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]