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
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
what is the difference between substr and instr function in oracle?
How to loop through data rows in the implicit cursor?
How does one get the view definition of fixed views/tables?
Explain about achiever in sql?
How to create tables for odbc connection testing?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
How will you identify oracle database software release?
Explain cascading triggers.
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to use "in out" parameter properly?
What is dynamic proxy?
what is the difference between restoring and recovering?
Whether any commands are used for months calculation? If so, what are they?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.