what is difference between cartesian join & cross join even
they give same result?
Answers were Sorted based on User's Feedback
Answer / shilpa
Both the joins give same result.Cross join is SQL 99 join
and Cartesian product is Oracle Propreitary join.
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / tapan
Both are giving same result but Cartesian product is oracle proprietary join and cross join is ANSI join .
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / prem
cross join gives some duplicate results but the cartesian
join give accurate result
Is This Answer Correct ? | 5 Yes | 12 No |
How do I call oracle stored procedures that take no parameters?
How to write a query with a full outer join in oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
Explain implicit cursor.
If a table column has is UNIQUE and has NOT NULL, is it equivalent to a PRIMARY KEY column?
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 call a stored function in oracle?
What is a trace file and how is it created in oracle?
What is connection pooling in oracle?
How do we switch from init.ora file to asp file?
Explain cascading triggers.