A CROSS JOIN in Oracle is a JOIN operation that produces the Cartesian product of two tables.
i,e if one of the table is having 100 rows and another one 8 rows, then cross join will produce 800 rows
Here table emp has 14 rows and second table as 1 rows,so total 14 rows are returned.
we can create another example table check this
So now total 28 rows are selected.
Cross Join does not let you specify a join clause. You may, however, specify a WHERE clause in the SELECT statement.
Cross join in another format can be written as
select a.* ,b.* from scott.emp a ,scott.example b ;
I hope you like this simple explanation of the cross join. Please do provide the feedback