Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL SDO_LRS Functions      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: SDO_LRS

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

 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 308 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?