2. Update the Geometry with those coordinates.
I'll assume you have a table called ADDRESS which has some sort of unique identifier, called ID, and a geometry column called GEOMETRY:
Find which ID's have 0,0 as location:
That'll give you the ID's. Updating those points could be done with something like this:
select adr.id from address adr where adr.geometry.sdo_point.x = 0 and adr.geometry.sdo_point.y = 0;
Modify the above as fitting your situation and data, and it should be ok. If you used Oracle' geocoding to create these points in the first place, you should be able to use that to do the update. If you explain a little bit more about your data, we can tweak the above SQL to do it in one go possibly.
update address adr set adr.geometry = MDSYS.SDO_GEOMETRY(2001,8307,MDSYS.SDO_POINT_TYPE(123456.12,123456.12,NULL),NULL,NULL) where adr.ID=1;
Here is the script I modified to collect the details :
from hr_locations_all adr
where adr.geometry.sdo_point.x = 0 and
adr.geometry.sdo_point.y = 0;
Copied 4 of the 35 records having problem with:
LOCATION_ID LOCATION_CODE ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 TOWN_OR_CITY COUNTRY POSTAL_CODE STYLE 361 Ontario PMED 8th Floor, Ferguson Block 77 Wellesley Street West Toronto CA M7A 1N3 CA 371 WCB Ontario 200 Front Street West Toronto CA M5V 3J1 CA 374 WCB Saskatchewan 200-1881 Scarth Street Regina CA S4P 4L1 CA 952 2006 - Edmonton AB 8930-82nd Ave NW Edmonton CA T6C 0Z3