sdo_elem_info elements
3728Jan 23 2008 — edited Jan 25 2008Hello,
I would like to select the data in the sdo_elem_info.
When I use this query:
select a.geom.sdo_elem_info
from test a where rownum =1
/
I get:
SDO_ELEM_INFO_ARRAY(1, 1003, 1, 605, 2003, 1)
I want to select it so it looks like this:
1|1003|1|605|2003|1
I have tried several ideas, and searched the archives.
None of these work:
select a.geom.sdo_elem_info(0)
from test a where rownum =1
/
select a.geom.sdo_elem_info_array(0)
from test a where rownum =1
/
select a.geom.sdo_elem_info.sdo_elem_info_array(0)
from test a where rownum =1
/
I am using sdo_util.getvertices to get the sdo_ordinates.
Any help is appreciated.
Thank you.
S