4.21 SDO_TOPO_MAP.GET_EDGE_NODES
Format
SDO_TOPO_MAP.GET_EDGE_NODES( topology IN VARCHAR2, topo_map IN VARCHAR2, edge_id IN NUMBER ) RETURN SDO_NUMBER_ARRAY;
Description
Returns an array with the ID numbers of the start and end nodes on the specified edge.
Parameters
- topology
-
Name of the topology that contains the edge, or a null value, as explained in Using GET_xxx Topology Functions. Must not exceed 20 characters.
- topo_map
-
Name of the TopoMap object, or a null value, as explained in Using GET_xxx Topology Functions. (TopoMap objects are explained in TopoMap Objects.)
- edge_id
-
Edge ID value of the edge.
Usage Notes
The topology
or topo_map
parameter should specify a valid name, as explained in Using GET_xxx Topology Functions.
If the edge starts and ends at a node, the ID number of the node is the first and last number in the array.
This function has no exact equivalent method in the TopoMap
class of the client-side Java API (described in Topology Data Model Java Interface). The getEdge
method returns a Java edge object of the oracle.spatial.topo.Edge
class.
Examples
The following example returns the ID numbers of the nodes on the edge whose edge ID value is 1. The returned array contains two nodes ID numbers, both of them 1 (for the same node), because the specified edge starts and ends at the node with node ID 1 and has a loop edge. (The example refers to definitions and data from Topology Built from Topology Data.)
SELECT SDO_TOPO_MAP.GET_EDGE_NODES(null, 'CITY_DATA_TOPOMAP', 1) FROM DUAL; SDO_TOPO_MAP.GET_EDGE_NODES(NULL,'CITY_DATA_TOPOMAP',1) -------------------------------------------------------------------------------- SDO_NUMBER_ARRAY(1, 1)
Parent topic: SDO_TOPO_MAP Package Subprograms