sql difference between two tables

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>;

1select * from tableA
2minus
3select * from tableB
4