| http://www.w3.org/ns/prov#value | - Code:String sqlQuery = SELECT lc.shape FROM location lc WHERE SDO_WITHIN_DISTANCE(lc.shape, mdsys.sdo_geometry(1,4326,NULL, mdsys.sdo_elem_info_array(1,1,1), mdsys.sdo_ordinate_array(5,5)), 'distance = 0.00005') = 'TRUE';Query query = em.createNativeQuery(sqlQuery);List locations = query.getResultList();here location is an entity which has a column named shape of type sdo_geometry. this query wo
|
