1 2 3 4
| select 'true' as XY, REPLACE(TO_CHAR(vh.GEOM.SDO_POINT.X),',','.') as X,REPLACE(TO_CHAR(vh.GEOM.SDO_POINT.Y),',','.') as Y, ID,HDR_NUM,HDR_CODE,HDR_INS_ETA,HDR_NUM_CHRONO,QUALITE
from MATABLE vh where ((QUALITE is null) or (upper(QUALITE) = 'NON'))
and MDSYS.SDO_RELATE(vh.GEOM,MDSYS.SDO_GEOMETRY(2003,41014,NULL,SDO_ELEM_INFO_ARRAY(1,1003,4),SDO_ORDINATE_ARRAY(780557.799753257,2084322.45727753,780957.799753257,2084322.45727753,780757.799753257,2084522.45727753)),'mask=ANYINTERACT querytype=WINDOW') = 'TRUE'
and HDR_INS_ETA = (select HDR_INS_ETA from MATABLE vh where ID = 18764.000000) |
Partager