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
- 14598 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 |
Explain oracle insert into command?
How many types of cluster table in Oracle?
Explain the family trees and connection by clause
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
what is the use of system.effective.date variable in oracle?
What is the difference between translate and replace?
how do u know the total no of rows in a table?
The join defined by the default data link is an outer join yes or no ?
Explain what are the different type of segments?
List the parts of a database trigger.
What the is the diff between local index and global index. give some example.
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Oracle General 
