Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table vertices (
    asset_id    varchar2(10),
    part_num    number,
    vertex_num  number,
    x           number,
    y           number,
    m           number);
insert into vertices (asset_id,part_num,vertex_num,x,y,m) values ('001',1, 1, 0,   5, 0);
1 rows affected

insert into vertices (asset_id,part_num,vertex_num,x,y,m) values ('001',1, 2, 10, 10, 11.18);
1 rows affected

insert into vertices (asset_id,part_num,vertex_num,x,y,m) values ('001',1, 3, 30,  0, 33.54);
1 rows affected

insert into vertices (asset_id,part_num,vertex_num,x,y,m) values ('001',2, 1, 50, 10, 33.54);
1 rows affected

insert into vertices (asset_id,part_num,vertex_num,x,y,m) values ('001',2, 2, 60, 10, 43.54);
1 rows affected

select * from vertices


ASSET_ID
PART_NUM
VERTEX_NUM
X
Y
M


001
1
1
0
5
0

001
1
2
10
10
11.18

001
1
3
30
0
33.54

001
2
1
50
10
33.54

001
2
2
60
10
43.54

ASSET_ID	PART_NUM	VERTEX_NUM	X	Y	M
001	1	1	0	5	0
001	1	2	10	10	11.18
001	1	3	30	0	33.54
001	2	1	50	10	33.54
001	2	2	60	10	43.54