SQL> select * from test;

        ID VALUE
---------- ------------------------------
         1 1,2,3,4,5,6,
         2 9,8,7,6,5,4,3

SQL> get rip
  1  create or replace procedure
  2  rip (n in number)
  3  as
  4  retval varchar2(30);
  5  a number;
  6  begin
  7  select value into retval from test where id=n;
  8  retval:=replace(retval,',');
  9  for mag in 1..length(retval) loop
 10     a:=substr(retval,mag,1);
 11     dbms_output.put_line(a);
 12  end loop;
 13* end;
SQL> /

Procedure created.

SQL> exec rip(1);
1
2
3
4
5
6

PL/SQL procedure successfully completed.

SQL> exec rip(2);
9
8
7
6
5
4
3

PL/SQL procedure successfully completed.

SQL>