6.75 SDO_NET.GET_NODE_TABLE_NAME
Format
SDO_NET.GET_NODE_TABLE_NAME( network IN VARCHAR2 ) RETURN VARCHAR2;
Description
Returns the name of the table that contains the nodes in a spatial network.
Usage Notes
This function returns the value of the NODE_TABLE_NAME column for the network in the USER_SDO_NETWORK_METADATA view (see Table 5-38 in xxx_SDO_NETWORK_METADATA Views).
Examples
The following example returns the name of the table that contains the nodes in the network named ROADS_NETWORK
.
SELECT SDO_NET.GET_NODE_TABLE_NAME('ROADS_NETWORK') FROM DUAL; SDO_NET.GET_NODE_TABLE_NAME('ROADS_NETWORK') -------------------------------------------------------------------------------- ROADS_NODES
Parent topic: SDO_NET Package Subprograms