将汉字数字字符串转换成阿拉伯数字

declare

str_mid varchar2(100);
str_end varchar2(100);
begin
  
for j in (select t.id,t.ques_desc from  cqdn_qa_list_tmp t) 
  loop 
for i in 1 .. length(j.ques_desc)
loop

case substr(j.ques_desc,i,1) 
  when '一' then str_mid:=1 ;
  when '二' then str_mid:=2 ;
  when '三' then str_mid:=3 ;
  when '四' then str_mid:=4 ;
  when '五' then str_mid:=5 ;
  when '六' then str_mid:=6 ;
  when '七' then str_mid:=7 ;
  when '八' then str_mid:=8 ;
  when '九' then str_mid:=9 ;       
  when '零' then str_mid:=0 ;    
end case;

str_end:=str_end||str_mid;
end loop;

dbms_output.put_line(str_end);

update cqdn_qa_list_tmp t set t.ques_desc = str_end  where t.id = j.id;
commit;
str_end:=null;
end loop;
end;