查询oracle srid 对应的EPSG代码
使用下面的oracle spatial函数可以查询srid 对应的EPSG代码
SDO_CS.MAP_ORACLE_SRID_TO_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.
- legacy_srid
-
Oracle Spatial SRID value. Must match a value in the LEGACY_CODE column of the SDO_COORD_REF_SYS table (see Section
6.7.9).
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.
To return the Oracle Spatial SRID value corresponding to a specified EPSG SRID value, use the SDO_CS.MAP_EPSG_SRID_TO_ORACLE function.
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
