select t1.* from (select * from TABLE_FACT minus select * from TABLE_FACT_TEST) t1
union
select t2.* from (select * from TABLE_FACT_TEST minus select * from TABLE_FACT) t2;
oracle对比两表不同数据
最新推荐文章于 2024-06-28 12:53:21 发布
select t1.* from (select * from TABLE_FACT minus select * from TABLE_FACT_TEST) t1
union
select t2.* from (select * from TABLE_FACT_TEST minus select * from TABLE_FACT) t2;