Cross join result sequence
If we have two tables and we do a cross join (cartesian product) on both tables then what will be the sequence of records after cross join. Will there be any sequence impact if number of records changes in any of the tables ?
For example if we two tables tab1 and tab2 then what will be the output of SELECT * from tab1, tab2
tab1
column1 column2
10 100
20 200
30 300
tab2
column1
40
41
42
43
Subject
Written By
Posted
Cross join result sequence
July 08, 2015 09:56AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.