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.

Parameters

network

Name of the network.

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;
/