How to get the x1,y1 and z1 coordinates out of an sdo_geometry object?
Hello,
i have stored several boxes into an sdo_geometry object like the following:
mdsys.sdo_geometry(3003,null,null,
mdsys.sdo_elem_info_array(1,1003,3),
mdsys.sdo_ordinate_array(x1,y1,z1,x2,y2,z2)
)
now i would like to get the x1,y1,z1 coordinates from the boxes. how can i get them with a simple sql-statement?
When i do "SELECT v.shape.sdo_ordinates ..." then i get a sdo_ordinate_array. But how can i get only the first coorinates?
I know how it works to get x1,y1 and z1 over a java-prog. But i want to get them with a sql-statement as i also want to get the min and max x1,y1,z1.
Hope there is anybody that can help me. Thanks in advance.
Markus Veith