Oracle Joins

There are 2 tables, A and B having 3 rows each. What will be result on executing the following query? : SQL> select * from A,B

Questions by sidd_130

Showing Answers 1 - 5 of 5 Answers

srikanth goduru

  • Oct 10th, 2012

A Cartesian product is the result of an unrestricted join of two or more tables. The result set of a three table Cartesian product will have x * y * z number of rows where x, y, z correspond to the number of rows in each table involved in the join. SO select * from a,b will result in 3x3= 9 rows


  • Apr 15th, 2013

Cross join. Total 9 records will come

  Was this answer useful?  Yes

jiley singh

  • May 21st, 2013

9 rows will be retreive

  Was this answer useful?  Yes

Arpit Agrawal

  • May 24th, 2013

Here simply answer would be 6. Since a is having 2 rows and b is having 3 rows. And we go for Cartesian join, which means 3*2=6.

  Was this answer useful?  Yes

Raju TT

  • Jun 11th, 2013

Cross join -cartesian product :Table a no. of rows (3) * Table b no.of rows (3)= cross join query returns 9 rows


  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions