SDO_LRS Archives - The Spatial Database Advisor

Oracle Spatial and Locator
Spatial Database Functions

Split Oracle Sdo_Geometry Linestring at a Known Point using SDO_LRS and PL/SQL (2)

30 Jun 2021 By Simon Greener

This article shows how to construct a function that allows any linestring to be split by any point using a collection of SDO_LRS procedures and functions.

Algorithms
Oracle Spatial and Locator

Snapping a Point to an Oracle Spatial SDO_GEOMETRY LineString

26 Jun 2021 By Simon Greener

This article shows how to snap a point to an Oracle Spatial linear geometry using the SDO_CLOSEST_POINTS procedure and function