joins - cheeyoung/sqlplus-public GitHub Wiki

Join Method	Operation
Sort Merge Join	MERGE JOIN	MERGE JOIN CARTESIAN

References

9.1 About Joins

If the statement does not specify a join condition, then the database performs a Cartesian join, matching every row in one table with every row in the other table.