Have a polygon in table 2 with its id, no and geometry. In table 1 I have polygons with the same fields. The polygon in table in intersects with a few polygons from table 1.What I am trying to do is clip of the polygons which overlap polygon from table 2 and insert the same fields and geometry in table 3
insert into table 3 select a.store_id,b.store_id,a.store_number,a.client_id,sdo_geom.sdo_intersection(b.geometry,a.geo metry,0.005) from table_1 a, table_2 b where b.store_id=34746 and sdo_anyinteract(b.geometry,a.geometry)='True'; When I do run this I dont get any output. Where would I be going wrong
أكثر...
insert into table 3 select a.store_id,b.store_id,a.store_number,a.client_id,sdo_geom.sdo_intersection(b.geometry,a.geo metry,0.005) from table_1 a, table_2 b where b.store_id=34746 and sdo_anyinteract(b.geometry,a.geometry)='True'; When I do run this I dont get any output. Where would I be going wrong
أكثر...