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
- What data is the same in both tables?
- 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) );