查询oracle srid 对应的EPSG代码

SDO_CS.MAP_ORACLE_SRID_TO_EPSG(

     legacy_srid IN NUMBER) RETURN NUMBER;

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

This function returns the SRID of an EPSG coordinate reference system. The EPSG SRID value for a coordinate reference system is indicated in the COORD_REF_SYS_CODE field in the EPSG Coordinate Reference System table.

The following example returns the EPSG SRID value corresponding to Oracle Spatial SRID 82361.

SELECT SDO_CS.MAP_ORACLE_SRID_TO_EPSG(82361) FROM DUAL;
 
SDO_CS.MAP_ORACLE_SRID_TO_EPSG(82361)                                           
-------------------------------------                                           
                                23038

转载自：https://blog.csdn.net/jxzz016590/article/details/38727957