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

Is sql developer case sensitive?

994

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1222

What is program debugging?

1240

Why is a trigger used?

936

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1201

What does the file extension accdb stand for?

968

What do we need to check in database testing?

1016

What is sql rowcount?

1002

What is rownum in sql?

1038

The select into statement is most often used to create backup copies of tables or for archiving records?

1062

How to display Row Number with Records in Oracle SQL Plus?

1043

What is meant by user defined function?

1046

How do I audit the sql sent to the server?

1002

Why do we create views in sql?

1148

What is record type in pl sql?

984