:select sdo_util.to_kmlgeometry(sdo_cs.transform(u.GEOM,8265)) from POWER

select sdo_util.to_kmlgeometry(sdo_cs.transform(u.GEOM,8265)) from POWER_3785

select srid, cs_name from MDSYS.CS_SRS where srid in (3785,8265,40983);
 SRID   CS_NAME
--------------------------------------------------------
 8265	Longitude / Latitude (NAD 83)
40983	California 0405, Zone V (1983, US Survey feet)

SELECT geom 
  FROM test_geom WHERE id=56195008;

(2001; 83032; ; (1; 1; 1; 3; 1; 0; ... ); (3294961.19712802; 5703830.25752743; 0; 1; ... ))     
        
SELECT SDO_UTIL.to_kmlgeometry (SDO_CS.transform (geom, 8265)) xml
  FROM test_geomt WHERE id=56195008;

<Point>
  <extrude>0</extrude>
  <tessellate>0</tessellate>
  <altitudeMode>relativeToGround</altitudeMode>
  <coordinates>45.251559362461,45.4259980027815</coordinates>
</Point>

SELECT SDO_UTIL.to_kmlgeometry (SDO_CS.transform (geom, 3785)) xml
  FROM test_geom WHERE id=56195008;

<Point>
  <extrude>0</extrude>
  <tessellate>0</tessellate>
  <altitudeMode>relativeToGround</altitudeMode>
  <coordinates>5037380.54583075,5658370.15886842</coordinates>
</Point>