Some software products can create 3D SDO_GEOMETRY
objects where the Z ordinate is NULL or 0. To use some of the Oracle Spatial processing functionality, the Z ordinate must be removed. While basic functions to do this are covered in the book Pro Oracle Spatial, variations are often needed. The following are introduced here:
Create Or Replace Type Body T_Geometry [...] /* Dimensional Adjustment */ Member Function ST_To2D Return T_Geometry Deterministic, Member Function ST_To3D(p_zordtokeep In Integer) Return T_Geometry Deterministic, Member Function ST_To3D(p_start_z In Number, p_end_z In Number, p_unit In varchar2 default null) Return T_Geometry Deterministic, Member Function ST_FixZ(p_default_z In Number := -9999 ) Return T_Geometry Deterministic,