chrismarx
asked on
Extract Contents Of Varray with SQL
Hi,
In oracle spatial, I can do this to get a list of varrays for each geometry record
select t.geometry.sdo_ordinates from table t
and i can do this to return the individual coordinates for one of those varrays
select * from table(select t.geometry.sdo_ordinates from table t where rownum = 1)
but what i would really like is a string with those coordinates concatenated together, for each varray
I know i can do this in pl/sql, but is there is a way to do this just in sql?
In oracle spatial, I can do this to get a list of varrays for each geometry record
select t.geometry.sdo_ordinates from table t
and i can do this to return the individual coordinates for one of those varrays
select * from table(select t.geometry.sdo_ordinates from table t where rownum = 1)
but what i would really like is a string with those coordinates concatenated together, for each varray
I know i can do this in pl/sql, but is there is a way to do this just in sql?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i guess the way to do this is really just create a pl/sql function to loop through the varray and then call it in sql
hmm, I'm not sure I understand what the problem is. Can you post some insert statements and sample output of what you'd like it to do? I'll see if I can figure out a SQL to do it.
ASKER
Im aware of stragg, but that really isnt my problem. I need to be able to do the above query but for the sub query in table without the use of the rownum