1b.3. Region Map (OCI360_REGIONS_SUBS)

Notes:
1) Locations are approximated
2)
 Name                                                                                Null?    Type
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 STATUS                                                                                       VARCHAR2(8)
 REGION_KEY                                                                                   VARCHAR2(4)
 REGION_NAME                                                                                  VARCHAR2(16)
 IS_HOME_REGION                                                                               VARCHAR2(4)


SELECT t1.region_name, t2.latitude, t2.longitude
FROM   OCI360_REGIONS_SUBS t1,
       "OCI360_LOCATION" t2
where  t1.region_key=t2.name;


1 rows selected.