In Oracle, CROSS JOIN is used to fetch all rows from both the tables, where each row in the result set is the combination from both the tables. This is happens because it does not have the join conditions.
To fetch all records from both the joined tables, 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 record from both "tblbankheadquartersandaddress" and "tblbankdemataccountcharges" tables using CROSS JOIN.