Definition:

In Oracle PL/SQL, **SDO_LRS** is a built in package which is owned by MDSYS user. It contains the subprograms that create, update, and query Linear Referencing Elements. The Linear Referencing System provides a way to link attributes to locations or other units of linear features in one-to-one relationships.

Some of SDO_LRS functions are listed below:

SDO_LRS.VALID_GEOM_SEGMENT: Checks validation property of a geometric segment.

SDO_LRS.VALID_LRS_PT: Checks LRS point validation.

SDO_LRS.VALID_MEASURE: Compares the current measure against the measure range of geometric segment.

SDO_LRS.CONNECTED_GEOM_SEGMENTS: Checks the relationship between two geometric segments.

SDO_LRS.GEOM_SEGMENT_LENGTH: Determines the length of geometric segment.

SDO_LRS.GEOM_SEGMENT_START_PT: It returns the start point of geometric segment.

SDO_LRS.GEOM_SEGMENT_END_PT: Determines the end point of geometric segment.

SDO_LRS.GEOM_SEGMENT_START_MEASURE: Returns the initial measure of geometric segment

SDO_LRS.GEOM_SEGMENT_END_MEASURE: Measures the last measure of geometric segment.

SDO_LRS.GET_MEASURE: Measures the LRS point.

SDO_LRS.GET_NEXT_SHAPE_PT: Returns a shape point on a geometric segment after the measure value is crossed.

SDO_LRS.GET_NEXT_SHAPE_PT_MEASURE: Returns measure of shape point on a geometric segment after the measure value is crossed.

SDO_LRS.GET_PREV_SHAPE_PT: Returns a shape point on a geometric segment prior to the measure value.

SDO_LRS.GET_PREV_SHAPE_PT_MEASURE: Returns measure of shape point on a geometric segment prior to the measure value.

SDO_LRS.IS_GEOM_SEGMENT_DEFINED: Checks the definition of LRS segment.

SDO_LRS.IS_MEASURE_DECREASING: Checks for the descending order of measure values.

SDO_LRS.IS_MEASURE_INCREASING: Checks for the increasing order of measure values.

Other SDO_GEOM functions include:

SDO_LRS.IS_SHAPE_PT_MEASURE, SDO_LRS.MEASURE_RANGE, SDO_LRS.MEASURE_TO_PERCENTAGE, SDO_LRS.PERCENTAGE_TO_MEASURE,SDO_LRS.LOCATE_PT,SDO_LRS.PROJECT_PT, SDO_LRS.FIND_LRS_DIM_POS, SDO_LRS.FIND_MEASURE, SDO_LRS.FIND_OFFSET, SDO_LRS.VALIDATE_LRS_GEOMETRY