i have the report: SELECT
D.KATHGORDX || ' ' || D.KATHGORAL1 || ' ' || D.KATHGORAL2 || ' ' || D.LANDTYPE AS DASIKOS_XARAKTHRA,
D.GEOMETRY,
D.DKAMK,
CASE D.KATHGORDX || D.KATHGORAL1
WHEN 'ΑΑ' THEN 1
ELSE 2
END AS XROMA
FROM
KAEK2025 K
JOIN
DX_MK_V2 D ON sdo_within_distance(K.GEOMETRY, D.GEOMETRY, 'distance=300 unit=meter') = 'TRUE'
WHERE
K.KAEK = :P9_KAEK; --→ it shows me full polygons, but i want to clip the big polygons at 300m, (i don't like the big full polygons)