Is there a way to build geometry into a materialized view that is transformed prior to insert?
So as an example say I have the following case:
t1.latitude is not null
t1.longitude is not null
THEN MDSYS.SDO_GEOMETRY(2001,40000, NULL,
But need to somehow incorporate this in the view definition:
MDSYS.SDO_CS.TRANSFORM(SDO_GEOMETRY(2001,4326,MDSYS.SDO_POINT_TYPE(t1.longitude, t1.latitude, NULL), NULL,NULL),40000))