There are 10 rows in Table A and 0 Rows in table B. Select * from A,BHow many rows will be retrieved.

10 rows
  • Interview Candidate
  • 7
  • 2422

Showing Answers 1 - 7 of 7 Answers

Suganya

  • Feb 16th, 2007
 

Hi,The basic funda in Oracle is Any addition,multiplication,division and joining two tables with one as null,Oracle will give the output only as Null.In your case there will be no rows selected.that is why the functionality of outerjoin is in Oracle.

  Was this answer useful?  Yes

akhil

  • Feb 19th, 2007
 

no rows will be selected

  Was this answer useful?  Yes

kiran

  • Feb 20th, 2007
 

No rows will be selected

  Was this answer useful?  Yes

nimisha agrawal

  • Mar 12th, 2007
 

it will not select any row.coz according to this query it has to give cartesian product.that means it will select m into n rowsso 10*0=0

  Was this answer useful?  Yes

nandk.sharma

  • Jun 27th, 2008
 

no rows will be retrieved.
The Cartesian product will only yield records when there is atleast one record in both the tables i.e.   A and B.

  Was this answer useful?  Yes

jasvinderss

  • Jun 30th, 2008
 

There could be two cases
(1) if you supply the query as Select * from A,B
you have not mentioned any join condition in this case 10 rows will be selected.
(2)if you supply a join condition with the above queries with a common filed between them, then in that case no rows will be selcted.

  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