1.刷存量数据
merge into 格式如下
merge into table_name alias1
using(table | view | sub_query) alisa2
on (join condition)
when matched then
update table_name set col1 = xx
when not matched then
insert into...........
Oracle随笔
发布时间 2023-09-18 14:52:30作者: 兵哥无敌
1.刷存量数据
merge into 格式如下
merge into table_name alias1
using(table | view | sub_query) alisa2
on (join condition)
when matched then
update table_name set col1 = xx
when not matched then
insert into...........