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



Leave a Reply 0

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