Return to Revisions

It looks like I can use the getvertices() function and the table() function :

select
    a.line_id,
    --sdo_util.getvertices(a.shape),
    b.id as vertex_id,
    b.x, b.y
from
    maximo.a_sdo_geometry_tbl a,
    table(sdo_util.getvertices(a.shape)) b
order by 
    a.line_id, b.id;


   LINE_ID  VERTEX_ID          X          Y
---------- ---------- ---------- ----------
         1          1 671539.685 4863324.18
         1          2 671595.050 4863343.17
         1          3 671614.014 4863350.34
         1          4 671622.204 4863353.53

         2          1 71534.5567 4863119.99
         2          2 671640.738 4863157.13
         2          3 671684.862 4863172.02

         3          1 671622.204 4863353.53
         3          2 671633.327 4863357.85
         3          3 671904.061 4863451.29

         4          1 671684.862 4863172.02
         4          2 671892.150 4863244.14
         4          3 671951.216 4863264.82
         4          4 671957.447 4863266.85
         4          5 671966.824 4863269.15

15 rows selected.