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
- 14975 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 |
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
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
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
How to list all indexes in your schema?
How to display the hierarchy of employee and managers without using connect by prior.
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
how to retrieve data from different tables ,place this data in different excel worksheets.
Explain an exception?
How do we get field detail of a table?
What is the usage of save points in oracle database?
Explain oracle 12c new features for developers?
Oracle General 
