Question

oracle如何比较两个表数据的差异？

Answer 1

est表：

test1表：

现在要找出两张表有差异的数据，需要用minus及union的方式查找出来，语句如下：

select t1.* from(select * from testminusselect * from test1) t1union select t2.* from(select * from test1minusselect * from test) 1

select t1.* from

(select * from test

minus

select * from test1) t1

union 

select t2.* from

(select * from test1

minus

select * from test) t2;

select t1.* from

(select * from test

minus

select * from test1) t1

union 

select t2.* from

(select * from test1

minus

select * from test) t2;

红框部分的数据就是有差异的内容。