It is a cross join So, the output is 5*2=10

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 / subbu

Answer Posted / subbu

It is a cross join

So, the output is 5*2=10

Is This Answer Correct ?

13 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the purpose of %type and %rowtype data types with the example?

1047

What is java sql package?

1145

What does fetching a cursor do?

1133

can a stored procedure call itself or recursive stored procedure? : Sql dba

1086

What is the difference between between and in condition operators?

1066

Why we use cross join?

1002

What are the types of join in sql?

1149

How many indexes can be created on a table in sql?

1114

What is file based approach?

1002

What are the ways on commenting in a pl/sql code?

1206

How do I view an execution plan in sql?

1036

What is meant by temporal data?

1004

How do I restart sql?

1026

How do you use collections in procedure to return the resultset?

2286

What does closing a cursor do?

1375