Cross Join in Oracle

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

Related Articles

self join in oracle with examples

oracle join syntax examples

What are Oracle Joins (Sql Joins)?

Various Joins Method in Oracle

Nested Loop Join in Oracle 11g

Leave a Reply