In Oracle, FULL OUTER JOIN is used to fetch all records from LEFT and RIGHT side table. It places NULL where the join condition is not met.
To fetch all records from LEFT and RIGHT side table, use the following syntax:
Parameters:
tablename1 & tablename2: The table name from which you want to fetch records.
col1: The column or field name that will be return.
Note:
In the above example, we are fetching all "banks" and "accountName" fields value from "tblbankheadquartersandaddress" and "accountName" field from "tblbankdemataccountcharges" table using FULL OUTER JOIN.