VIEW: CSF.CSF_ELOC_TDS_ROUTE_CACHE#

Source

View Text - Preformatted

select SEGMENT_FROM SEGMENT_FROM, SIDE_FROM SIDE_FROM, SPOT_FROM SPOT_FROM, SEGMENT_TO SEGMENT_TO, SIDE_TO SIDE_TO, SPOT_TO SPOT_TO, RESULTTIME RESULTTIME, RESULTDISTANCE RESULTDISTANCE, DATETIME DATETIME, HITCOUNT HITCOUNT, ROUTE_CACHE_ID ROUTE_CACHE_ID, GEOMETRY GEOMETRY, SECURITY_GROUP_ID SECURITY_GROUP_ID, ROUTE ROUTE, TO_SEGMENT_ID TO_SEGMENT_ID, CONFIG CONFIG, TIME TIME, DISTANCE DISTANCE, COST COST, RAMHITCOUNT RAMHITCOUNT, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, FROM_SEGMENT_SIDE FROM_SEGMENT_SIDE, TO_SEGMENT_SIDE TO_SEGMENT_SIDE, FROM_SEGMENT_POSITION FROM_SEGMENT_POSITION, TO_SEGMENT_POSITION TO_SEGMENT_POSITION, FROM_SEGMENT_ID FROM_SEGMENT_ID, LAT_FROM LAT_FROM, LON_FROM LON_FROM, LAT_TO LAT_TO, LON_TO LON_TO from "CSF"."CSF_ELOC_TDS_ROUTE_CACHE"

View Text - HTML Formatted

SELECT SEGMENT_FROM SEGMENT_FROM
, SIDE_FROM SIDE_FROM
, SPOT_FROM SPOT_FROM
, SEGMENT_TO SEGMENT_TO
, SIDE_TO SIDE_TO
, SPOT_TO SPOT_TO
, RESULTTIME RESULTTIME
, RESULTDISTANCE RESULTDISTANCE
, DATETIME DATETIME
, HITCOUNT HITCOUNT
, ROUTE_CACHE_ID ROUTE_CACHE_ID
, GEOMETRY GEOMETRY
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ROUTE ROUTE
, TO_SEGMENT_ID TO_SEGMENT_ID
, CONFIG CONFIG
, TIME TIME
, DISTANCE DISTANCE
, COST COST
, RAMHITCOUNT RAMHITCOUNT
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, FROM_SEGMENT_SIDE FROM_SEGMENT_SIDE
, TO_SEGMENT_SIDE TO_SEGMENT_SIDE
, FROM_SEGMENT_POSITION FROM_SEGMENT_POSITION
, TO_SEGMENT_POSITION TO_SEGMENT_POSITION
, FROM_SEGMENT_ID FROM_SEGMENT_ID
, LAT_FROM LAT_FROM
, LON_FROM LON_FROM
, LAT_TO LAT_TO
, LON_TO LON_TO
FROM "CSF"."CSF_ELOC_TDS_ROUTE_CACHE"