This SQL tutorial focuses on cross join in Oracle, and provides explanations, examples
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 oracle 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
Related Articles
self join in oracle with examples
What are Oracle Joins (Sql Joins)?
Various Joins Method in Oracle
Nested Loop Join in Oracle 11g