6.67 SDO_NET.GET_NO_OF_HIERARCHY_LEVELS
Format
SDO_NET.GET_NO_OF_HIERARCHY_LEVELS( network IN VARCHAR2 ) RETURN NUMBER;
Description
Returns the number of hierarchy levels for a network.
Usage Notes
This function returns the value of the NO_OF_HIERARCHY_LEVELS column for the network in the USER_SDO_NETWORK_METADATA view (see Table 5-38 in xxx_SDO_NETWORK_METADATA Views).
For an explanation of network hierarchy, see Network Hierarchy.
Examples
The following example returns the number of hierarchy levels for the network named ROADS_NETWORK
.
SELECT SDO_NET.GET_NO_OF_HIERARCHY_LEVELS('ROADS_NETWORK') FROM DUAL; SDO_NET.GET_NO_OF_HIERARCHY_LEVELS('ROADS_NETWORK') --------------------------------------------------- 1
Parent topic: SDO_NET Package Subprograms