3v4l.org

run code in 150+ php & hhvm versions
Bugs & Features
<?php echo "SELECT h.SEQSUP as ID, " . "h.GEOMETRY.get_wkt() as GEOM " . "FROM TRANLINK.SUPPORT h " . "WHERE h.GEOMETRY.get_wkt() IS NOT NULL " . "AND SDO_RELATE(h.GEOMETRY, " . "SDO_GEOMETRY (2003, 327680, NULL, " . "SDO_ELEM_INFO_ARRAY(1,1003,3), " . "SDO_ORDINATE_ARRAY(:LatSW,:LongSW,:LatNE,:LongNE)), " . "0.5') = 'TRUE'";
Output for 5.3.0 - 7.1.0
SELECT h.SEQSUP as ID, h.GEOMETRY.get_wkt() as GEOM FROM TRANLINK.SUPPORT h WHERE h.GEOMETRY.get_wkt() IS NOT NULL AND SDO_RELATE(h.GEOMETRY, SDO_GEOMETRY (2003, 327680, NULL, SDO_ELEM_INFO_ARRAY(1,1003,3), SDO_ORDINATE_ARRAY(:LatSW,:LongSW,:LatNE,:LongNE)), 0.5') = 'TRUE'