Answer Posted / ron
Cartesian product includes rows from all the tables where
there is no specific criteria to join on.
it does not necessarily mean that there is no where clause
it can have a where clause where you filter data set from
table a, table b, c... and then join these tables to give
you the product of the join.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How to delete multiple rows from a table in oracle?
How to define an explicit cursor in oracle?
How do I know if oracle is installed on windows?
What is the difference between translate and replace?
Describe an oracle table?
What is the use of aggregate functions in oracle?
How to create an oracle database manually?
Can a parameter be passed to a cursor?
What is archive log in Oracle?
How to list all indexes in your schema?
What happens if variable names collide with table/column names?
How to assign query results to variables?
What are the differences between char and varchar2 in oracle?
What is the difference between view and materialized view in Oracle?
State the difference between a primary key and foreign key?