22.28 SDO_CS.MAP_EPSG_SRID_TO_ORACLE
Format
SDO_CS.MAP_EPSG_SRID_TO_ORACLE( epsg_srid IN NUMBER) RETURN NUMBER;
Description
Returns the Oracle Spatial SRID value corresponding to the specified EPSG SRID value.
Parameters
Usage Notes
This function returns a value that matches a value in the SRID column of the SDO_COORD_REF_SYS table (see SDO_COORD_REF_SYS Table).
To return the EPSG SRID value corresponding to the specified Oracle Spatial SRID value, use the SDO_CS.MAP_ORACLE_SRID_TO_EPSG function.
Examples
The following example returns the Oracle Spatial SRID value corresponding to EPSG SRID 23038.
SELECT SDO_CS.MAP_EPSG_SRID_TO_ORACLE(23038) FROM DUAL; SDO_CS.MAP_EPSG_SRID_TO_ORACLE(23038) ------------------------------------- 82361
Parent topic: SDO_CS Package (Coordinate System Transformation)