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
State and explain the different types of data models?
What is the parameter mode that can be passed to a procedure?
How does oracle handle read consistency?
How to export data with a field delimiter?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What's dateware house and what's clustor with practicle example
How to create a stored program unit?
What is a cursor in oracle?
How do we represent comments in oracle?
Can we create database in oracle using command line ?
What privilege is needed for a user to create indexes in oracle?
Who developed oracle & when?
What is the difference between count (*), count (expression), count (distinct expression)?
What is where clause in oracle?
How to create a new table in your schema?