oci360 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.

oci360 (c) 2020, All rights reserved. oci360 v20.06 (2020-06-25) based on moat369 v2002 (2020-02-27). Timestamp: 2020-06-30T15:50:04