Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select regexp_substr(to_char('14521;65412;65845'),'[^;]+', 1, level)
from dual
connect BY regexp_substr(to_char('14521;65412;65845'), '[^;]+', 1, level)
is not null


REGEXP_SUBSTR(TO_CHAR('14521;65412;65845'),'[^;]+',1,LEVEL)


14521

65412

65845


select regexp_substr(to_char('1;0;1'),'[^;]+', 1, level)
from dual
connect BY regexp_substr(to_char('1;0;1'), '[^;]+', 1, level)
is not null


REGEXP_SUBSTR(TO_CHAR('1;0;1'),'[^;]+',1,LEVEL)


1

0

1


select c.cod, f.flag
from (
  select level as n, regexp_substr(to_char('14521;65412;65845'),'[^;]+', 1, level) as cod
  from dual
  connect BY regexp_substr(to_char('14521;65412;65845'), '[^;]+', 1, level)
  is not null
) c
join (
  select level as n, regexp_substr(to_char('1;0;1'),'[^;]+', 1, level) as flag
  from dual
  connect BY regexp_substr(to_char('1;0;1'), '[^;]+', 1, level)
  is not null
) f
on f.n = c.n


COD
FLAG


14521
1

65412
0

65845
1


select regexp_substr(to_char('14521;65412;65845'),'[^;]+', 1, level) as cod,
  regexp_substr(to_char('1;0;1'),'[^;]+', 1, level) as flag
from dual
connect BY regexp_substr(to_char('14521;65412;65845'), '[^;]+', 1, level)
is not null


COD
FLAG


14521
1

65412
0

65845
1