Interested to Buy Any Domain ? << Click Here >> for more details...
what is difference between cartesian join & cross join even
they give same result?
- 4 Answers
- 14794 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 does oracle handle read consistency?
what is the syntax of CREATE command?
What is a recycle bin in oracle?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is the function of Redo Log ?
How to connect to oracle using service name instead of sid?
what are the default admin accounts in Oracle 10g ?
Explain the use of indexes option in imp command.
What is a directory object?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
what is Single Byte Overhead...?
Oracle General 
