Oracle中获取字符串中的数字:
- create or replace function GetNumber(str varchar2) return varchar2 IS
- v_temp varchar2(200) ;
- v_return varchar2(200) ;
- idx number :=1 ;
- BEGIN
- WHILE(idx <= LENGTH(str) ) LOOP
- v_temp := SUBSTR(str,idx,1) ;
- if(ASCII(UPPER(v_temp)) >= 48 AND ASCII(UPPER(v_temp)) <= 57) then
- v_return := v_return||v_temp ;
- END IF ;
- idx := idx + 1 ;
- END LOOP ;
- return v_return ;
- end GetNumber;