[Home] [Help] [Dependency Information]
Object Name: | CSF_ELOC_TDS_ROUTE_CACHE# |
---|---|
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEGMENT_FROM | NUMBER | |||
SIDE_FROM | NUMBER | |||
SPOT_FROM | NUMBER | |||
SEGMENT_TO | NUMBER | |||
SIDE_TO | NUMBER | |||
SPOT_TO | NUMBER | |||
RESULTTIME | NUMBER | |||
RESULTDISTANCE | NUMBER | |||
DATETIME | DATE | |||
HITCOUNT | NUMBER | |||
ROUTE_CACHE_ID | NUMBER | (30) | ||
GEOMETRY | SDO_GEOMETRY | (64) | ||
SECURITY_GROUP_ID | NUMBER | |||
ROUTE | CLOB | (4000) | ||
TO_SEGMENT_ID | NUMBER | (15) | ||
CONFIG | VARCHAR2 | (100) | ||
TIME | NUMBER | (15) | ||
DISTANCE | NUMBER | (15) | ||
COST | NUMBER | (15) | ||
RAMHITCOUNT | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
FROM_SEGMENT_SIDE | VARCHAR2 | (1) | ||
TO_SEGMENT_SIDE | VARCHAR2 | (1) | ||
FROM_SEGMENT_POSITION | VARCHAR2 | (3) | ||
TO_SEGMENT_POSITION | VARCHAR2 | (3) | ||
FROM_SEGMENT_ID | NUMBER | (15) | ||
LAT_FROM | FLOAT | (22) | ||
LON_FROM | FLOAT | (22) | ||
LAT_TO | FLOAT | (22) | ||
LON_TO | FLOAT | (22) |
Cut, paste (and edit) the following text to query this object:
SELECT SEGMENT_FROM
, SIDE_FROM
, SPOT_FROM
, SEGMENT_TO
, SIDE_TO
, SPOT_TO
, RESULTTIME
, RESULTDISTANCE
, DATETIME
, HITCOUNT
, ROUTE_CACHE_ID
, GEOMETRY
, SECURITY_GROUP_ID
, ROUTE
, TO_SEGMENT_ID
, CONFIG
, TIME
, DISTANCE
, COST
, RAMHITCOUNT
, CREATION_DATE
, LAST_UPDATE_DATE
, FROM_SEGMENT_SIDE
, TO_SEGMENT_SIDE
, FROM_SEGMENT_POSITION
, TO_SEGMENT_POSITION
, FROM_SEGMENT_ID
, LAT_FROM
, LON_FROM
, LAT_TO
, LON_TO
FROM CSF.CSF_ELOC_TDS_ROUTE_CACHE#;
|
|
|