Function dynamically separate values from the given string like(10,20,30,40,50,60,70,80,90,100)

Function  dynamically separate values from the given string like(10,20,30,40,50,60,70,80,90,100) and store the values in Table called mytempvals

Made by Tahir Khalid

create or replace function separate5(a varchar2)return number

is

begin

for i in 1..9 loop

insert into mytempvals

select substr(a,instr(a,',',1,i)-2,2) from dual;

end loop;

commit;

return 1;

end;