insert into A select * from B where not exists (select 1 from A where A.ID=B.ID)
insert when (not exists (select 1 from 表名 where 检验重复的条件)) then into 表名 values(相应的值)select 1 from dual
时间: 2024-10-31 21:44:49
insert into A select * from B where not exists (select 1 from A where A.ID=B.ID)
insert when (not exists (select 1 from 表名 where 检验重复的条件)) then into 表名 values(相应的值)select 1 from dual