Use Spatial Functions Examples

1.  Function get_point_high
SQL> select get_point_high(121, 23) from dual;

GET_POINT_HIGH(121,23)
----------------------
                  2292

2. Function get_line_high
SQL> select get_line_high(120,22, 121,24) from dual

GET_LINE_HIGH(120,22,121,24)
----------------------------
                  284.309862

3. procedure get_line_every_high_points
SQL> EXECUTE get_line_every_high_points(120,22,121,24)
SQL>
SQL> select * from dem_result;

         X          Y          Z
---------- ---------- ----------
120.999612 23.9991496       1088
120.999612  23.999322       1101
120.999784 23.9996668       1105
120.999957 23.9998392       1107
120.999957 24.0000116       1110


3998 rows selected.