By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with vertices as (
select 001 asset_id,1 part_num,1 vertex_num,0 x,5 y,0 m from dual union all
select 001,1,2,10,10,11.18 from dual union all
select 001,1,3,30,0,33.54 from dual union all
select 001,2,1,50,10,33.54 from dual union all
select 001,2,2,60,10,43.54 from dual
)
select * from vertices
| ASSET_ID | PART_NUM | VERTEX_NUM | X | Y | M |
|---|---|---|---|---|---|
| 1 | 1 | 1 | 0 | 5 | 0 |
| 1 | 1 | 2 | 10 | 10 | 11.18 |
| 1 | 1 | 3 | 30 | 0 | 33.54 |
| 1 | 2 | 1 | 50 | 10 | 33.54 |
| 1 | 2 | 2 | 60 | 10 | 43.54 |