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?
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 to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
Can we create table in function?
Can a table contain multiple foreign key’s?
How to display the current date in sql?
what is the difference between truncate and drop statements? : Sql dba
Why is sql*loader direct path so fast?
What is sql*loader?
How to write a query to show the details of a student from students table whose
What is tuple in sql?
Can you do multiple joins in sql?
What do you understand by exception handling in pl/sql?
How do you use collections in procedure to return the resultset?
define sql update statement ? : Sql dba
What are the different tcl commands in sql?
Does a user_objects view have an entry for a trigger?