You could of course transform the data into geodetic, calculate and tranfsorm back:
--calculate point 1000m 0° (north)
-- use WGS84 geodetic (8307) / ETRS89 UTM32 projected /25832)
SELECT SDO_CS.TRANSFORM(
SDO_UTIL.POINT_AT_BEARING(
SDO_CS.TRANSFORM(
SDO_GEOMETRY(2001, 25832,SDO_POINT_TYPE(634176, 5618187, NULL), NULL, NULL),
8307),
0,1000),
25832)
FROM DUAL;
-- SDO_GEOMETRY(2001, 25832,SDO_POINT_TYPE(634150.34, 5619186.49, NULL), NULL, NULL),
--check the distance in projected -> aproximate
SELECT SDO_GEOM.SDO_DISTANCE(
SDO_GEOMETRY(2001, 25832,SDO_POINT_TYPE(634176.00, 5618187.00, NULL), NULL, NULL),
SDO_GEOMETRY(2001, 25832,SDO_POINT_TYPE(634150.34, 5619186.49, NULL), NULL, NULL),
0.1)
FROM dual;
--999.82
--check the distance in geodetic -> exact
-- it is exactly northern
SELECT SDO_GEOM.SDO_DISTANCE(
SDO_GEOMETRY(2001, 8307,SDO_POINT_TYPE(10.9000100360663, 50.7089939346931, NULL), NULL, NULL),
SDO_GEOMETRY(2001, 8307,SDO_POINT_TYPE(10.9000100360663, 50.7000045737259, NULL), NULL, NULL),
0.1)
FROM dual;
--999.999995296258