what is difference between cartesian join & cross join even
they give same result?
Answer Posted / 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 |
Post New Answer View All Answers
How do I reset a sequence in oracle?
What are transaction isolation levels supported by oracle?
State some uses of redo log files?
How to convert numbers to characters in oracle?
What is an oracle database?
What are the differences between primary key and unique key?
How do I spool to a csv formatted file using sqlplus?
Explain about your project and its relation to the current job position you are applying to?
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.
State any two functions of oracle?
How to apply filtering criteria at group level in oracle?
Can we write dml statement in function in oracle?
How to view the tablespaces in the current database?
How to connect the oracle server as sysdba?
What is the sql query to concatenate column values from multiple rows in oracle?