6.87 SDO_NET.IS_NODE_IN_PATH
Format
SDO_NET.IS_NODE_IN_PATH( network IN VARCHAR2, path_id IN NUMBER, node_id IN NUMBER, ) RETURN VARCHAR2;
Description
Returns the string TRUE
if the specified node is in the specified path; returns the string FALSE
if the specified node is not in the specified path.
Usage Notes
You can use this function to check if a specific node is included in a specific path.
Examples
The following example checks if the node with node ID 1 is in the path with path ID 1 in the network named SDO_NET1
.
SELECT SDO_NET.IS_NODE_IN_PATH('SDO_NET1', 1, 1) FROM DUAL; SDO_NET.IS_NODE_IN_PATH('SDO_NET1',1,1) -------------------------------------------------------------------------------- TRUE
Parent topic: SDO_NET Package Subprograms