您当前的位置:首页 > 文章教程 > 计算机与互联网 > 数据库

oracle中merge into用法及实例解析

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]

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]