[Home] [Help] [Dependency Information]
Object Name: | CSF_TDS_ROUTE_CACHE_AU# |
---|---|
Object Type: | VIEW |
Owner: | CSF |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_CACHE_ID | NUMBER | (30) | ||
SEGMENT_FROM | NUMBER | |||
SIDE_FROM | NUMBER | |||
SPOT_FROM | NUMBER | |||
SEGMENT_TO | NUMBER | |||
SIDE_TO | NUMBER | |||
SPOT_TO | NUMBER | |||
RESULTTIME | NUMBER | |||
RESULTDISTANCE | NUMBER | |||
ROUTE | CLOB | (4000) | ||
DATETIME | DATE | |||
HITCOUNT | NUMBER | |||
SECURITY_GROUP_ID | NUMBER | |||
FROM_SEGMENT_ID | NUMBER | (15) | ||
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) |
Cut, paste (and edit) the following text to query this object:
SELECT ROUTE_CACHE_ID
, SEGMENT_FROM
, SIDE_FROM
, SPOT_FROM
, SEGMENT_TO
, SIDE_TO
, SPOT_TO
, RESULTTIME
, RESULTDISTANCE
, ROUTE
, DATETIME
, HITCOUNT
, SECURITY_GROUP_ID
, FROM_SEGMENT_ID
, 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 CSF.CSF_TDS_ROUTE_CACHE_AU#;
|
|
|