Oracle 11g Release 2

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

create table your_table (name, quantity, barcode) as
select 'Apple', 5, 'barcode1;barcode2;barcode3' from dual
union all
select 'Samsung', 4, 'barcode1' from dual
2 rows affected

select name, regexp_substr(barcode, '(.*?)(;|$)', 1, level, null, 1)
from your_table
connect by name = prior name
and prior sys_guid() is not null
and level <= quantity;


NAME
REGEXP_SUBSTR(BARCODE,'(.*?)(;|$)',1,LEVEL,NULL,1)


Apple
barcode1

Apple
barcode2

Apple
barcode3

Apple
null

Apple
null

Samsung
barcode1

Samsung
null

Samsung
null

Samsung
null


with rcte (name, pos, barcode, quantity, all_barcodes) as (
  select name, 1, regexp_substr(barcode, '(.*?)(;|$)', 1, 1, null, 1), quantity, barcode
  from your_table
  union all
  select name, pos + 1, regexp_substr(all_barcodes, '(.*?)(;|$)', 1, pos + 1, null, 1), quantity, all_barcodes
  from rcte
  where pos < quantity
)
select name, barcode
from rcte
order by name, pos;


NAME
BARCODE


Apple
barcode1

Apple
barcode2

Apple
barcode3

Apple
null

Apple
null

Samsung
barcode1

Samsung
null

Samsung
null

Samsung
null

NAME	REGEXP_SUBSTR(BARCODE,'(.*?)(;\|$)',1,LEVEL,NULL,1)
Apple	barcode1
Apple	barcode2
Apple	barcode3
Apple	null
Apple	null
Samsung	barcode1
Samsung	null
Samsung	null
Samsung	null