Explanation/Reference:
MDSYS.CS_SRS defines the valid coordinate systems.
The MDSYS.CS_SRS table associates each coordinate system with its well-known text description, which is in conformance with the standard published by the OpenGIS Consortium (http://www.opengis.org).
The MDSYS.CS_SRS reference table is included with Oracle Spatial, and it is used by coordinate systems functions and procedures. This table contains over 900 rows, one for each valid coordinate system.
Note: The MDSYS.CS_SRS Table (Column Name, Data Type, Description)
CS_NAME, VARCHAR2(68)
A well-known name, often mnemonic, by which a user can refer to the coordinate system.
SRID, INTEGER
The unique ID number (Spatial Reference ID) for a coordinate system.
AUTH_SRID, INTEGER
An optional ID number that can be used to indicate how the entry was derived; it might be a foreign key into another coordinate table, for example.
AUTH_NAME, VARCHAR2(256)
An authority name for the coordinate system. Contains 'Oracle' in the supplied table. Users can specify any value in any rows that they add.
WKTEXT, VARCHAR2(2046)
The well-known text (WKT) description of the SRS, as defined by the OpenGIS Consortium.
CS_BOUNDS, MDSYS.SDO_GEOMETRY
Optional SDO_GEOMETRY object that is a polygon with WGS-84 longitude and latitude vertices, representing the spheroidal polygon description of the zone of validity for a projected coordinate system.
Must be null for a geographic or non-Earth coordinate system. Is null in all supplied rows.
References: https://docs.oracle.com/cd/A87860_01/doc/inter.817/a85337/sdo_cs_c.htm