1(SELECT * FROM T1 MINUS SELECT * FROM T2) -- Rows that are in T1 but not in T2
2UNION ALL
3(SELECT * FROM T2 MINUS SELECT * FROM T1); -- Rows that are in T2 but not in T1
1-- Oracle
2
3-- Example
4SELECT *
5FROM Table1 -- the table containing extra records
6 MINUS
7 SELECT *
8 FROM Table2;
9
10-- Syntax
11SELECT *
12FROM <table-1> -- the table containing extra records
13 MINUS
14 SELECT *
15 FROM <table-2>;