The MDSYS.SDO_CS package contains subprograms 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).
To use the subprograms in this chapter, you must understand the conceptual information about coordinate systems in Coordinate System and Coordinate Systems (Spatial Reference Systems).
Table 201 lists the coordinate system transformation subprograms.
Table 201 Subprograms for Coordinate System Transformation
Subprogram  Description 

Adds a preference for an operation between a source coordinate system and a target coordinate system. 

Converts a threedimensional SRID value into a twodimensional SRID value. 

Converts a NADCON (North American Datum Conversion) grid in ASCII format to an Oracle Spatial and Graph XML representation. 

Converts an NTv2 (National Transformation Version 2) grid in ASCII format to an Oracle Spatial and Graph XML representation. 

Converts an Oracle Spatial and Graph XML representation of a NADCON (North American Datum Conversion) grid to NADCON ASCII format. 

Converts an Oracle Spatial and Graph XML representation of an NTv2 (National Transformation Version 2) grid to NTv2 ASCII format. 

Creates a concatenated operation. 

Creates a basic set of EPSG rules to be applied in certain transformations. 

Creates a concatenated operation, associating it with a transformation plan and making it preferred either systemwide or for a specified use case. 

Deletes the basic set of EPSG rules to be applied in certain transformations. 

Deletes a concatenated operation. 

Returns the query chain, based on the system rule set, to be used in transformations from one coordinate reference system to another coordinate reference system. 

Returns the default chain of SRID values in transformations from one coordinate reference system to another coordinate reference system. 

Returns the SRID values of geodetic (geographic) coordinate reference systems that have the same wellknown text (WKT) numeric values as the coordinate reference system with the specified reference SRID value. 

Returns the SRID values of projected coordinate reference systems that have the same wellknown text (WKT) numeric values as the coordinate reference system with the specified reference SRID value. 

Finds an SRID value for a coordinate system that matches information that you specify. 

Converts a wellknown text string from the Open Geospatial Consortium simple feature format without the 

Converts a point represented in U.S. National Grid format to a spatial point geometry object. 

Gets the version number of the EPSG dataset used by Spatial and Graph. 

Converts a threedimensional (or more dimensions) geometry into a twodimensional geometry. 

Converts a twodimensional geometry into a threedimensional geometry. 

Returns the Oracle Spatial and Graph SRID values corresponding to the specified EPSG SRID value. 

Returns the EPSG SRID value corresponding to the specified Oracle Spatial and Graph SRID value. 

Revokes a preference for an operation between a source coordinate system and a target coordinate system. 

Converts a wellknown text string from the Open Geospatial Consortium simple feature format that includes the 

Transforms a geometry representation using a coordinate system (specified by SRID or name). 

Transforms an entire layer of geometries (that is, all geometries in a specified column in a table). 

Updates the wellknown text (WKT) description for all EPSG coordinate reference systems. 

Updates the wellknown text (WKT) description for the EPSG coordinate reference system associated with a specified SRID. 

Updates the wellknown text (WKT) description for all EPSG coordinate reference systems associated with a specified datum. 

Updates the wellknown text (WKT) description for all EPSG coordinate reference systems associated with a specified ellipsoid. 

Updates the wellknown text (WKT) description for all EPSG coordinate reference systems associated with a specified coordinate transformation operation. 

Updates the wellknown text (WKT) description for all EPSG coordinate reference systems associated with a specified coordinate transformation operation and parameter for transformation operations. 

Updates the wellknown text (WKT) description for all EPSG coordinate reference systems associated with a specified prime meridian. 

Validates the wellknown text (WKT) description associated with a specified SRID. 
The rest of this chapter provides reference information on the subprograms, listed in alphabetical order.