what is difference between cartesian join & cross join even
they give same result?
- 4 Answers
- 15078 Views
- Bank Of America, I also Faced
- E-Mail Answers
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 to truncate date and get only time part 9:20:00
What would you do if a database crashes in production?
can we pass two out parameters at a time in function?please answer to my question
How to use values from other tables in update statements using oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
How to convert numbers to characters in oracle?
when i run my query on yesterday it is fast but today it is slow why?
What is the scope of a local variable?
Explain the use of indexes option in exp command.
How to create an oracle database?
how to find find & delete duplicate rows from two different tables?
Oracle General 
