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
- 12910 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer Posted / manda
It gives a cartesian product or a cross product.
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
How can you fetch common records from two tables?
What is varray in pl sql?
How to select random rows from a table?
Why is sql*loader direct path so fast?
Does group by remove duplicates?
Is it possible to read/write files to-and-from PL/SQL?
Why stored procedure is better than query?
what is csv? : Sql dba
What is flag in sql?
Sql technical questions
How do you explain an index number?
What is Difference Between Unique and Primary Key Constraints?
How do I save a stored procedure?
Is primary key an index?
How do you declare a variable in pl sql?
