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


Please Help Members By Posting Answers For Below Questions

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

910


Can we create table in function?

574


Can a table contain multiple foreign key’s?

579


How to display the current date in sql?

603


what is the difference between truncate and drop statements? : Sql dba

558






Why is sql*loader direct path so fast?

603


What is sql*loader?

576


How to write a query to show the details of a student from students table whose

542


What is tuple in sql?

547


Can you do multiple joins in sql?

550


What do you understand by exception handling in pl/sql?

579


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

1793


define sql update statement ? : Sql dba

584


What are the different tcl commands in sql?

624


Does a user_objects view have an entry for a trigger?

573