Welcome to 16892 Developer Community-Open, Learning,Share
menu search
person

Categories

I am using Oracle 11G.

I have a table called Tickets in the schema called 'tickets1" I have the same table structure in another schema called 'tickets2'

I want to find out

  1. What data is the same in both tables?
  2. What data is different?
CREATE TABLE tickets(
    ticket_number NUMBER NOT NULL,    
    first_name VARCHAR2(50) NOT NULL,
    last_name VARCHAR2(50) NOT NULL,
    PRIMARY KEY(ticket_number)
);

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
268 views
Welcome To Ask or Share your Answers For Others

1 Answer

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)

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to 16892 Developer Community-Open, Learning and Share
...