Hi,
say I have a table 'geometry' and I want to insert its fields "lat" and "long" into my other table "locations" with the SDO_Geometry (object) orientated datatype field "here", what is the syntax for this (ignore the correlation, I know that bit....)
{code}
insert into locations (here)
(select (x, y)
from geometry)
{code}
Anyone tell me what to put in place of (x, y), does (lat, long) work???
thanks,
Robert.