4.32 SDO_TOPO_MAP.GET_NODE_COORD
Format
SDO_TOPO_MAP.GET_NODE_COORD( topology IN VARCHAR2, topo_map IN VARCHAR2, node_id IN NUMBER ) RETURN SDO_GEOMETRY;
Description
Returns an SDO_GEOMETRY object with the coordinates of the specified node.
Parameters
- topology
-
Name of the topology that contains the node, 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.)
- node_id
-
Node ID value of the node.
Usage Notes
The topology
or topo_map
parameter should specify a valid name, as explained in Using GET_xxx Topology Functions.
This function is equivalent to using the getNodeCoord
method of the TopoMap
class of the client-side Java API (described in Topology Data Model Java Interface).
Examples
The following example returns a geometry object with the coordinates of the node whose node ID value is 14. (The example refers to definitions and data from Topology Built from Topology Data.)
SELECT SDO_TOPO_MAP.GET_NODE_COORD(null, 'CITY_DATA_TOPOMAP', 14) FROM DUAL; SDO_TOPO_MAP.GET_NODE_COORD(NULL,'CITY_DATA_TOPOMAP',14)(SDO_GTYPE, SDO_SRID, SD -------------------------------------------------------------------------------- SDO_GEOMETRY(2001, 0, SDO_POINT_TYPE(21, 14, NULL), NULL, NULL)
Parent topic: SDO_TOPO_MAP Package Subprograms