oracle中merge into的写法
时间: 2023-12-02 17:03:51 浏览: 71
Oracle merge into用法
Merge into是一种用于将数据从一个表格合并到另一个表格的SQL语句。下面是语法:
MERGE INTO table_name
USING source_table
ON (merge_condition)
WHEN MATCHED THEN
UPDATE SET column_name = source_table.column_name
WHEN NOT MATCHED THEN
INSERT (column_name) VALUES (source_table.column_name)
阅读全文