6.72 SDO_NET.GET_NODE_GEOMETRY
Format
SDO_NET.GET_NODE_GEOMETRY( network IN VARCHAR2, node_id IN NUMBER ) RETURN SDO_GEOMETRY;
Description
Returns the LRS geometry associated with a node in a spatial network.
Usage Notes
None.
Examples
The following example returns the geometry associated with the node whose node ID is 3 in the network named ROADS_NETWORK
.
SELECT SDO_NET.GET_NODE_GEOMETRY('ROADS_NETWORK', 3) FROM DUAL; SDO_NET.GET_NODE_GEOMETRY('ROADS_NETWORK',3)(SDO_GTYPE, SDO_SRID, SDO_POINT(X, Y -------------------------------------------------------------------------------- SDO_GEOMETRY(2001, NULL, SDO_POINT_TYPE(8, 4, NULL), NULL, NULL)
Parent topic: SDO_NET Package Subprograms