what is difference between cartesian join & cross join even
they give same result?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to apply filtering criteria at group level in oracle?

589


Explain the use of grant option in exp command.

586


How to connect asp pages to oracle servers?

581


How to start your 10g xe server?

603


How does one get the view definition of fixed views/tables?

608






Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1678


What is a oracle database?

615


What happens if you lost a data file?

586


What is open database communication (odbc) in oracle?

551


How to select some columns from a table in oracle?

558


What is the string concatenation operator in oracle?

574


Difference between open_form and call_form in oracle.

684


Whats the benefit of dbms_stats over analyze?

1499


In the oracle version 9.3.0.5.0, what does each number shows?

754


How to create a stored function in oracle?

593