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?
- 7 Answers
- 11969 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / santosh pashte
It is concept of CROSS JOIN..
It will display 5 * 2 = 10 rows
| Is This Answer Correct ? | 41 Yes | 4 No |
Post New Answer View All Answers
What is replication id?
Mention what does the hierarchical profiler does?
Explain what is rdbms?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What are the two types of exceptions in pl/sql?
what are the advantages of mysql in comparison to oracle? : Sql dba
what is auto increment? : Sql dba
What is index example?
Why are sql stored procedures used?
What can you do with pl sql?
Is coalesce faster than isnull?
what is 'trigger' in sql? : Sql dba
Define overloaded procedure?
What is database white box testing and black box testing?
What is the basic structure of an sql?
