Oracle SQL 1999 syntax supports the same functionality with which join type?

Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables:
SQL> SELECT C.COUNTRY_name.
2> r.region_name
3> FROM countries c, region r ;
Oracle SQL 1999syntax supports the same functionality with which join type?

Examine this statement, which creates a Cartesian product of the COUNTRIES and REGION tables:
SQL> SELECT C.COUNTRY_name.
2> r.region_name
3> FROM countries c, region r ;
Oracle SQL 1999 syntax supports the same functionality with which join type?

A.
Equijoin

B.
Cross join

C.
Merge join

D.
Natural join

Show Hint

Leave a Reply 1

Your email address will not be published. Required fields are marked *

networkmanagers

networkmanagers

I have the same idea.

Reply