INSERT INTO MDSYS.CS_SRS S
(CS_NAME, SRID, AUTH_SRID, AUTH_NAME, WKTEXT)
VALUES
('Turkish Coordinate System ITRF 39',
1000004021,
1000004021,
'Oracle',
'PROJCS["ITRF96 / TM39",
GEOGCS["GCS_ITRF_1996",
DATUM["D_ITRF_1996",
SPHEROID["GRS_1980",6378137,298.257222101]],
PRIMEM["Greenwich",0],
UNIT["Decimal Degree",0.017453292519943295]],
PROJECTION["Transverse Mercator"],
PARAMETER["central_meridian",39],
PARAMETER["latitude_of_origin",0],
PARAMETER["scale_factor",1],
PARAMETER["false_easting",500000],
PARAMETER["false_northing",0],
UNIT["Meter",1]]');
commit;
SELECT SDO_CS.VALIDATE_WKT(1000004021) FROM DUAL;