A cross join, or product provides the foundation upon which all types of inner joins operate. A cross join returns the Cartesian product of the sets of records from the two joined tables. Thus, it equates to an inner join where the join-condition always evaluates to true or join-condition is absent in statement. This command is introduced for Oracle9i. If A and B are two sets, then the cross join is written as A x B.
Example: SQL> SELECT ENAME, DEPT.DEPTNO FROM EMP CROSS JOIN DEPT;
Explanation: After execution this command will return all the employees multiplied the departments. And it will again return 56 rows.