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