SELECT SDO_OWNER OWNER,
NETWORK,
NETWORK_ID,
NETWORK_CATEGORY,
GEOMETRY_TYPE,
NETWORK_TYPE,
NO_OF_HIERARCHY_LEVELS,
NO_OF_PARTITIONS,
LRS_TABLE_NAME,
LRS_GEOM_COLUMN,
NODE_TABLE_NAME,
NODE_GEOM_COLUMN,
NODE_COST_COLUMN,
NODE_PARTITION_COLUMN,
NODE_DURATION_COLUMN,
LINK_TABLE_NAME,
LINK_GEOM_COLUMN,
LINK_DIRECTION,
LINK_COST_COLUMN,
LINK_PARTITION_COLUMN,
LINK_DURATION_COLUMN,
PATH_TABLE_NAME,
PATH_GEOM_COLUMN,
PATH_LINK_TABLE_NAME,
SUBPATH_TABLE_NAME,
SUBPATH_GEOM_COLUMN,
PARTITION_TABLE_NAME,
PARTITION_BLOB_TABLE_NAME,
COMPONENT_TABLE_NAME,
NODE_LEVEL_TABLE_NAME,
TOPOLOGY,
USER_DEFINED_DATA,
EXTERNAL_REFERENCES,
CHILD_NETWORK,
HIERARCHY_TABLE_NAME
FROM SDO_NETWORK_METADATA_TABLE
SELECT SDO_OWNER OWNER
,
NETWORK
,
NETWORK_ID
,
NETWORK_CATEGORY
,
GEOMETRY_TYPE
,
NETWORK_TYPE
,
NO_OF_HIERARCHY_LEVELS
,
NO_OF_PARTITIONS
,
LRS_TABLE_NAME
,
LRS_GEOM_COLUMN
,
NODE_TABLE_NAME
,
NODE_GEOM_COLUMN
,
NODE_COST_COLUMN
,
NODE_PARTITION_COLUMN
,
NODE_DURATION_COLUMN
,
LINK_TABLE_NAME
,
LINK_GEOM_COLUMN
,
LINK_DIRECTION
,
LINK_COST_COLUMN
,
LINK_PARTITION_COLUMN
,
LINK_DURATION_COLUMN
,
PATH_TABLE_NAME
,
PATH_GEOM_COLUMN
,
PATH_LINK_TABLE_NAME
,
SUBPATH_TABLE_NAME
,
SUBPATH_GEOM_COLUMN
,
PARTITION_TABLE_NAME
,
PARTITION_BLOB_TABLE_NAME
,
COMPONENT_TABLE_NAME
,
NODE_LEVEL_TABLE_NAME
,
TOPOLOGY
,
USER_DEFINED_DATA
,
EXTERNAL_REFERENCES
,
CHILD_NETWORK
,
HIERARCHY_TABLE_NAME
FROM SDO_NETWORK_METADATA_TABLE
|
|
|