Both are giving same result but Cartesian product is oracle proprietary joi

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

Question Posted / tapan

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

Please Help Members By Posting Answers For Below Questions

What happens to the current transaction if a ddl statement is executed?

573

How to delete a column in an existing table?

589

Please explain joins in oracle?

546

How to insert a record into a table?

633

How to open a cursor variable?

602

What is Data Dictionary Cache in Oracle?

657

Explain the use of inctype option in exp command.

590

Give the advantages and disadvantages of clusters.

570

How to calculate date and time differences in oracle?

527

How to create a temporary table in oracle?

687

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1790

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

743

Explain how are indexes update?

619

What privilege is needed for a user to connect to oracle server?

555

What is bulk collect in oracle?

547