oracle merge not matched 能否执行update

2025-03-10 22:33:40
推荐回答(1个)
回答1:

不可以。not matched then 后面只能跟insert into 语句。具体语法:
merge
into table_name
using table_view_or_query
on condition
when matched then update_clause
delete where_clause
when not matched then insert_clause