Le portail francophone de la géomatique

SELECT S.GID_D,
       S.GID_A,
       S.CLASS,
       S.NAME
       || NTILE (
             4)
          OVER (
             ORDER BY
                SDO_GEOM.SDO_DISTANCE (S.BASIAS_GEOMETRY, S.PARC_GEOMETRY, 1) DESC),
       S."TYPE",
       SDO_GEOM.SDO_DISTANCE (S.BASIAS_GEOMETRY, S.PARC_GEOMETRY, 1)
  FROM (SELECT                                                  /*+ ORDERED */
               BASIAS.GID "GID_D",
               BASIAS.GEOMETRY AS BASIAS_GEOMETRY,
               PARC.GID "GID_A",
               PARC.GEOMETRY AS PARC_GEOMETRY,
               'PCI_PARC' "CLASS",
               'BASIAS_' AS NAME,
               0 "TYPE"
          FROM A_REIMS.BASIAS BASIAS, A_REIMS.PCI_PARC PARC
         WHERE SDO_WITHIN_DISTANCE (PARC.GEOMETRY,
                                    BASIAS.GEOMETRY,
                                    'distance=200') = 'TRUE'
               ) S
               ;