Update a table with values from coordinates on GEOMETRY in Oracle

[المشرف العام]

I have 2 columns in a table that represent the X and Y coordinates. The values in those columns don't match the actual coordinates and I want to update them with the coordinates values that are selected from the GEOMETRY column. I have been trying the following:

update TABLE1 set X = (SELECT t.X FROM TABLE1 Tb, table(SDO_UTIL.GETVERTICES(Tb.GEOMETRY )) t); but I am getting the following error:

ORA-01427: single-row subquery returns more than one row

Any suggestions?



أكثر...