Hi
Apex 24.2
I have text field that holds a list of barcodes (comma seperated).
I need to split this list into individual barcodes and save into a collection.
The below code splits the list but how do I save this into a collection
with rws as (
select ',leading,commas,and,trailing,' str from dual
)
select regexp_substr (
str,
'[^,]+',
1,
level
) value
from rws
connect by level <=
length ( trim ( both ',' from str ) ) -
length ( replace ( str, ',' ) ) + 1;
Any help appreciated
Regards
Gus