Oracle 23c

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

CREATE TABLE main
(
  morderno varchar(2),
  mgroup varchar(2),
  mseq number(1),
  mitem varchar(3),
  mamt number(2),
  munitprice number(5)
)
insert into main values
 ('P1','GA',1,'A01',11,111)
,('P1','GA',2,'A02',12,112)
,('P1','GB',1,'B01',13,113)
,('P1','GB',2,'B02',14,114)
,('P1','GC',1,'C01',15,115)
,('P1','GC',2,'C02',16,116)
  ;
6 rows affected

insert into main values 
 ('P2','GA',1,'A01',21,221)
,('P2','GB',1,'B01',22,222)
,('P2','GC',1,'C01',23,223)
;
3 rows affected

insert into main values 
 ('P3','GB',2,'B02',31,331)
,('P3','GC',2,'C02',32,332)
;
2 rows affected

SELECT * FROM MAIN


MORDERNO
MGROUP
MSEQ
MITEM
MAMT
MUNITPRICE


P1
GA
1
A01
11
111

P1
GA
2
A02
12
112

P1
GB
1
B01
13
113

P1
GB
2
B02
14
114

P1
GC
1
C01
15
115

P1
GC
2
C02
16
116

P2
GA
1
A01
21
221

P2
GB
1
B01
22
222

P2
GC
1
C01
23
223

P3
GB
2
B02
31
331

P3
GC
2
C02
32
332

MORDERNO	MGROUP	MSEQ	MITEM	MAMT	MUNITPRICE
P1	GA	1	A01	11	111
P1	GA	2	A02	12	112
P1	GB	1	B01	13	113
P1	GB	2	B02	14	114
P1	GC	1	C01	15	115
P1	GC	2	C02	16	116
P2	GA	1	A01	21	221
P2	GB	1	B01	22	222
P2	GC	1	C01	23	223
P3	GB	2	B02	31	331
P3	GC	2	C02	32	332

MORDERNO	MGROUP	MSEQ	MITEM	MAMT	MUNITPRICE
P1	GA	1	A01	11	111
P1	GA	2	A02	12	112
P1	GB	1	B01	13	113
P1	GB	2	B02	14	114
P1	GC	1	C01	15	115
P1	GC	2	C02	16	116
P2	GA	1	A01	21	221
P2	GB	1	B01	22	222
P2	GC	1	C01	23	223
P3	GB	2	B02	31	331
P3	GC	2	C02	32	332

MORDERNO	MGROUP	MSEQ	MITEM	MAMT	MUNITPRICE
P1	GA	1	A01	11	111
P1	GA	2	A02	12	112
P1	GB	1	B01	13	113
P1	GB	2	B02	14	114
P1	GC	1	C01	15	115
P1	GC	2	C02	16	116
P2	GA	1	A01	21	221
P2	GB	1	B01	22	222
P2	GC	1	C01	23	223
P3	GB	2	B02	31	331
P3	GC	2	C02	32	332