For same data, use INTERSECT
SELECT * FROM TICKETS1.TICKETS
INTERSECT
SELECT * FROM TICKETS2.TICKETS
For difference of data, use MINUS
and UNION
as follows
SELECT * FROM
(SELECT * FROM TICKETS1.TICKETS
MINUS
SELECT * FROM TICKETS2.TICKETS)
UNION
(SELECT * FROM TICKETS2.TICKETS
MINUS
SELECT * FROM TICKETS1.TICKETS)
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…