Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

ALTER SESSION SET NLS_DATE_FORMAT = 'yyyymmdd';
CREATE TABLE table1 (id) AS
SELECT LEVEL FROM DUAL WHERE LEVEL != 6 CONNECT BY LEVEL <= 7;
6 rows affected

CREATE TABLE table2 (id) AS
SELECT LEVEL FROM DUAL WHERE LEVEL NOT IN (1, 5, 7) CONNECT BY LEVEL <= 9;
6 rows affected

SELECT COALESCE(t1.id, t2.id) AS id,
       NVL2(t1.id, 'Not in table2', 'Not in table1') AS status
FROM   table1 t1
       FULL OUTER JOIN table2 t2
       ON t1.id = t2.id
WHERE  t1.id IS NULL
OR     t2.id IS NULL


ID
STATUS


6
Not in table1

8
Not in table1

9
Not in table1

7
Not in table2

5
Not in table2

1
Not in table2

ID	STATUS
6	Not in table1
8	Not in table1
9	Not in table1
7	Not in table2
5	Not in table2
1	Not in table2