A SERVICE OF

logo

40 | Chapter 4 Enhanced Layer Functionality
Note Using parameters when applying a geometry function is optional.
Supported Geometry Functions
The following is a list of some of the supported geometry functions that are
available with Oracle:
SDO_ARC_DENSIFY
SDO_BUFFER
SDO_CENTROID
SDO_CONVEXHULL
SDO_MBR
Note Consult your Oracle documentation for a complete list of Oracle functions
available in Oracle and for instructions on how to use them.
Sample Applied Geometry Functions
In this example, Oracle is creating a buffer around land parcels. It is simply
one of several ways that you can use geometry functions to analyze and
manipulate data without changing the original data in the database.
In the following sample, the parameter %GEOMCOL is used to substitute the
geometry column name for the parameter. This parameter is optional, and
you can use it to specify a geometry function without having to write a
specific geometry column in the request.