Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table mytable (pos_id varchar2(10), pos_count number(10));
insert into mytable (pos_id, pos_count) values ('A', 2);
1 rows affected

insert into mytable (pos_id, pos_count) values ('B', 2);
1 rows affected

insert into mytable (pos_id, pos_count) values ('C', 1);
1 rows affected

insert into mytable (pos_id, pos_count) values ('D', 3);
1 rows affected

insert into mytable (pos_id, pos_count) values ('E', 999);
1 rows affected

with cte (pos_id, pos_count, pos_seq) as
(
  select pos_id, pos_count, 1 from mytable
  union all
  select pos_id, pos_count, pos_seq + 1
  from cte
  where pos_seq < pos_count and pos_count <> 999
)
select *
from cte
order by pos_id, pos_seq;


POS_ID
POS_COUNT
POS_SEQ


A
2
1

A
2
2

B
2
1

B
2
2

C
1
1

D
3
1

D
3
2

D
3
3

E
999
1