SQL> get rip_number;
  1  create or replace function rip (f_in varchar2)
  2  return varchar2 as
  3  v_in varchar2(30);
  4  opt varchar2(30);
  5  retval varchar2(30);
  6  dumm varchar2(30);
  7  begin
  8  v_in:=replace(f_in,' ');
  9  for mag in 1..length(v_in) loop
 10     opt:=substr(v_in,mag,1);
 11     if is_number(opt,1,1)='Y'  then
 12     dumm:=dumm||opt;
 13     end if;
 14     end loop;
 15  return dumm;       
 16* end;
SQL> /

Function created.

SQL> select rip(col1) from test10;

RIP(COL1)
--------------------------------------------------------------------------------
0078965432
24579893
23794832
0078434521

SQL>