6.42 SDO_NET.GET_CHILD_NODES
Format
SDO_NET.GET_CHILD_NODES( network IN VARCHAR2, node_id IN NUMBER ) RETURN SDO_NUMBER_ARRAY;
Description
Returns the child nodes of a node.
Usage Notes
For information about parent and child nodes and links in a network hierarchy, see Network Hierarchy.
Examples
The following example returns the child nodes of the node in the XYZ_NETWORK
network whose node ID is 1.
SELECT SDO_NET.GET_CHILD_NODES('XYZ_NETWORK', 1) FROM DUAL; SDO_NET.GET_CHILD_NODES('XYZ_NETWORK',1) -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(101, 102, 103, 104, 105, 106)
Parent topic: SDO_NET Package Subprograms