It gives a cartesian product or a cross product.

there is A table and B table in A table there 5 rows and in
b table there are 2 rows i am firing query select * from
a,b what will be the output?

Question Posted / manda

Answer Posted / manda

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is an exception in PL/SQL? What are the two types of exceptions?

1312

What are the usages of sql?

1058

what is a composite key ? : Sql dba

1062

Explain the structure of pl/sql in brief.

1095

What is the purpose of the partition table?

1049

Whis is not false in primary key?

1457

Is subquery faster than join?

1014

What is procedure and function in sql?

1001

What is user in sql?

1024

What are the types of functions in sql?

1020

How to assign sql query results to pl sql variables?

1081

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1227

How to test for null values?

1052

How does cross join work?

960

Can we use having without group by in sql?

982