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
What is the purpose of tables, private synonyms and public synonyms in Oracle?
What is the max number of columns in an oracle table?
How to define an anonymous procedure with variables?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to return top 5 rows in oracle?
What are the oracle differences between nvl and coalesce
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the four Oracle system processes that must always be up and running for the database to be useable?
How to start instance with a minimal initialization parameter file?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Difference between varchar and varchar2 data types?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What do you know about normalization? Explain in detail?
How to install oracle database 10g xe?
What is dynamic proxy?