6.69 SDO_NET.GET_NO_OF_NODES
Format
SDO_NET.GET_NO_OF_NODES( network IN VARCHAR2 ) RETURN NUMBER;
or
SDO_NET.GET_NO_OF_NODES( network IN VARCHAR2, hierarchy_id IN NUMBER ) RETURN NUMBER;
Description
Returns the number of nodes for a network or a hierarchy level in a network.
Parameters
Usage Notes
For information about nodes and related concepts, see Network Data Model Concepts.
Examples
The following example returns the number of nodes in the network named ROADS_NETWORK
.
SELECT SDO_NET.GET_NO_OF_NODES('ROADS_NETWORK') FROM DUAL; SDO_NET.GET_NO_OF_NODES('ROADS_NETWORK') ---------------------------------------- 8
Parent topic: SDO_NET Package Subprograms