eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: MDSYS.ALL_SDO_NETWORK_METADATA

Object Details

Object Name:	ALL_SDO_NETWORK_METADATA
Object Type:	VIEW
Owner:	MDSYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
OWNER	VARCHAR2	(32)	Yes
NETWORK	VARCHAR2	(24)	Yes
NETWORK_ID	NUMBER		Yes
NETWORK_CATEGORY	VARCHAR2	(12)	Yes
GEOMETRY_TYPE	VARCHAR2	(24)
NETWORK_TYPE	VARCHAR2	(24)
NO_OF_HIERARCHY_LEVELS	NUMBER
NO_OF_PARTITIONS	NUMBER
LRS_TABLE_NAME	VARCHAR2	(32)
LRS_GEOM_COLUMN	VARCHAR2	(32)
NODE_TABLE_NAME	VARCHAR2	(32)	Yes
NODE_GEOM_COLUMN	VARCHAR2	(32)
NODE_COST_COLUMN	VARCHAR2	(1024)
NODE_PARTITION_COLUMN	VARCHAR2	(32)
NODE_DURATION_COLUMN	VARCHAR2	(32)
LINK_TABLE_NAME	VARCHAR2	(32)	Yes
LINK_GEOM_COLUMN	VARCHAR2	(32)
LINK_DIRECTION	VARCHAR2	(12)	Yes
LINK_COST_COLUMN	VARCHAR2	(1024)
LINK_PARTITION_COLUMN	VARCHAR2	(32)
LINK_DURATION_COLUMN	VARCHAR2	(32)
PATH_TABLE_NAME	VARCHAR2	(32)
PATH_GEOM_COLUMN	VARCHAR2	(32)
PATH_LINK_TABLE_NAME	VARCHAR2	(32)
SUBPATH_TABLE_NAME	VARCHAR2	(32)
SUBPATH_GEOM_COLUMN	VARCHAR2	(32)
PARTITION_TABLE_NAME	VARCHAR2	(32)
PARTITION_BLOB_TABLE_NAME	VARCHAR2	(32)
COMPONENT_TABLE_NAME	VARCHAR2	(32)
NODE_LEVEL_TABLE_NAME	VARCHAR2	(32)
TOPOLOGY	VARCHAR2	(32)
USER_DEFINED_DATA	VARCHAR2	(1)
EXTERNAL_REFERENCES	VARCHAR2	(1)
CHILD_NETWORK	VARCHAR2	(32)
HIERARCHY_TABLE_NAME	VARCHAR2	(32)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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 MDSYS.ALL_SDO_NETWORK_METADATA;

Dependencies

[top of page]

MDSYS.ALL_SDO_NETWORK_METADATA references the following:

MDSYS: SDO_NETWORK_METADATA_TABLE

MDSYS.ALL_SDO_NETWORK_METADATA is referenced by following:

PUBLIC: ALL_SDO_NETWORK_METADATA