The SDO_CS
package contains functions and procedures for working with coordinate systems. You can perform explicit coordinate transformations on a single geometry or an entire layer of geometries (that is, all geometries in a specified column in a table).
For a complete description of this package within the context of Oracle Spatial, see SDO_CS
in the Oracle Spatial User's Guide and Reference.