oracle merge
语法:
merge [hint] into [schema .] table [t_alias]
using [schema .] { table | view | subquery } [t_alias]
on ( condition )
when matched then merge_update_clause
when not matched then merge_insert_clause;
创建测试数据表:
create table tj_test(id number,name varchar2(20),age number);
向表中插入数据:
insert into tj_test values (1,'jan',23);
insert into tj_test values (2,'kk',22);
insert into tj_test values (3,'joe',27);
select * from tj_test;
查询结果如下:
1 jan 23
2 kk 2......
阅读全文