Explanation/Reference:
SDO_GEOM.SDO_AREA
Format
SDO_GEOM.SDO_AREA(
geom IN SDO_GEOMETRY,
dim IN SDO_DIM_ARRAY
[, unit IN VARCHAR2]
) RETURN NUMBER;
or
SDO_GEOM.SDO_AREA(
geom IN SDO_GEOMETRY,
tol IN NUMBER
[, unit IN VARCHAR2]
) RETURN NUMBER;
Description
Returns the area of a two-dimensional polygon.
Parameters
geom
Geometry object.
dim
Dimensional information array corresponding to geom, usually selected from one of the xxx_SDO_GEOM_METADATA views.
unit
Unit of measurement: a quoted string with unit= and an SDO_UNIT value from the MDSYS.SDO_AREA_UNITS table (for example, 'unit=SQ_KM').
If this parameter is not specified, the unit of measurement associated with the data is assumed. For geodetic data, the default unit of measurement is square meters.
tol
Tolerance value
References: https://docs.oracle.com/database/121/SPATL/sdo_geom-sdo_area.htm#SPATL1110