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

network

Network name.

hierarchy_id

Hierarchy level number for which to return the number of nodes.

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