[Home] [Help] [Dependency Information]
Object Name: | CSF_WOM_CITY_CAPITAL |
---|---|
Object Type: | TABLE |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
DEFINITION
This table defines POI (point of interest) of capital of the countries for Map Display
EXAMPLE
MISCELLANEOUS
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SYS_IL0000395730C00013$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
SYS_IL0000395730C00014$$ | LOB | UNIQUE | APPS_TS_TX_DATA |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POI_ID | NUMBER | (17) | Yes | A unique identifier for the POI. |
ISO_COUNTRY_CODE | VARCHAR2 | (3) | Yes | Country code of the POI. |
OC | VARCHAR2 | (23) | OC of POI | |
NAME | VARCHAR2 | (255) | Yes | The NAME defines the name the POI. |
POPULATION | NUMBER | (10) | The POPULATION defines the estimated number of inhabitans of the city. | |
CAPITAL_LEVEL | NUMBER | (10) | Yes | Capital level of POI. |
GEOMETRY | SDO_GEOMETRY | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT POI_ID
, ISO_COUNTRY_CODE
, OC
, NAME
, POPULATION
, CAPITAL_LEVEL
, GEOMETRY
FROM CSF.CSF_WOM_CITY_CAPITAL;
|
|
|