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 drop a stored procedure in oracle?

592


What is oracle sid?

509


Explain what are the different type of segments?

578


How to install oracle database 10g xe?

562


Explain how you would restore a database using RMAN to Point in Time?

1636






You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1458


What is a sub query? Describe its types?

544


What is data block in Oracle?

618


what is the difference between substr and instr function in oracle?

584


List out the difference between commit, rollback, and savepoint?

618


What privilege is needed for a user to create views in oracle?

589


material view and view disadvantages?

635


What is format trigger?

1616


Can a parameter be passed to a cursor?

600


What is a package in oracle?

565