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 |
find the second highest salary of the emp table
Please explain compound trigger in oracle?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
Can a View based on another View ?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
What is Rollback Segment ?
How to apply filtering criteria at group level in oracle?
How to export your connection information to a file?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to use like conditions in oracle?
Can sub procedure/function be called recursively?