表结构一致的话:
insert into a (select * from b minus select * from a);
表结构不一致的话:
insert into a select .. from b where not exists (select ... from a where ...)
insert into a (select * from b minus select * from a);
表结构不一致的话:
insert into a select .. from b where not exists (select ... from a where ...)
select *
from b
where exist(select * from a where a.column <> b.column)