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 are the arithmetic operations?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to grant create session privilege to a user in oracle?
State some uses of redo log files?
Explain alias?
Explain the use of indexes option in imp command.
what is Single Byte Overhead...?
Is a rollback possible to any savepoint?
What is oracle and what are its different editions?
How to synchronize 2 schema's objects?
What are the execution control statements in oracle?
How to add a new column to an existing table in oracle?
How to call a sub procedure?
What is oracle join syntax?
How to convert csv to table in oracle?