Many functions (some dependent on others) have been created, but over time, an even larger library of (possibly interdependent) functions may come into existence, which may increase fragility unless dependencies are managed, and the compilation of each function occurs in the right order. In addition, it may be necessary to call a specific function in different ways even though they all implement exactly the same functionality.
Oracle offers us a number of ways to handle these situations.
The ST_Dimension function must be called with an SDO_GEOMETRY parameter. However, it may be more efficient to call the function with an SDO_GEOMETRY object's SDO_GTYPE numeric attribute; after all, the ST_Dimension function's processing is based entirely on this attribute. The current ST_Dimension function cannot be called with a non-SDO_GEOMETRY parameter value:
With testGeom As (
Select SDO_GEOMETRY(3302,NULL,NULL,
...