Hello,
Suppose I have a varchar column where numbers are stored delimited by a coma, like this:
create table x (
labno number(8),
tests varchar2(30)
);
insert into tests values(1, '03,11,45,77,99,116');
select tests from x;
result:
03,11,45,77,99,116
How would I extract numbers from this string and have have printed on different lines, like this:
03
11
45
77
99
116
Thank you!