6.45 SDO_NET.GET_DANGLING_NODES
Format
SDO_NET.GET_DANGLING_NODES( network IN VARCHAR2 ) RETURN SDO_NUMBER_ARRAY;
Description
Returns nodes that are not referenced by any feature in any feature layer.
Usage Notes
To delete the dangling nodes in a network, use the SDO_NET.DELETE_DANGLING_NODES procedure.
Examples
The following example gets the dangling nodes in the GRID
network and then displays the number (count) of dangling nodes found.
DECLARE node_ids SDO_NUMBER_ARRAY; BEGIN node_ids := sdo_net.get_dangling_nodes('GRID'); dbms_output.put_line('Number of dangling Nodes: '||node_ids.count); END; /
Parent topic: SDO_NET Package Subprograms