[Home] [Help] [Dependency Information]
Object Name: | WSH_LOCATION_DATA_EXT# |
---|---|
Object Type: | VIEW |
Owner: | WSH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOCATION_ID | NUMBER | |||
ZIP_CODE | VARCHAR2 | (40) | ||
DST_INDICATOR | VARCHAR2 | (1) | ||
GMT_OFFSET | NUMBER | |||
DST_START_DATE | DATE | |||
DST_END_DATE | DATE | |||
COUNTRY | VARCHAR2 | (100) | ||
STATE | VARCHAR2 | (100) | ||
COUNTY | VARCHAR2 | (100) | ||
CITY | VARCHAR2 | (100) | ||
ADMIN_BOUND_ID | NUMBER | |||
ZIP_CENTROID | SDO_GEOMETRY | (64) |
Cut, paste (and edit) the following text to query this object:
SELECT LOCATION_ID
, ZIP_CODE
, DST_INDICATOR
, GMT_OFFSET
, DST_START_DATE
, DST_END_DATE
, COUNTRY
, STATE
, COUNTY
, CITY
, ADMIN_BOUND_ID
, ZIP_CENTROID
FROM WSH.WSH_LOCATION_DATA_EXT#;
|
|
|