PL/SQL: Full Outer Join

Question: You have two tables, A and B. You want to see data of both the tables, that is common together with the data that is not common between them. The data should not repeat. If the data is there in table A, but not table B, the output should show NULL values for B. Similarly, if the data is there in table B, but not table A, the output should show NULL values for A.

Answer: Full Outer Join