Oracle 自定义进制转化为10进制

----1.建立function

create or replace function to_azTdec
( p_str in varchar2,
p_from_base in number default 26 ) return number------和进制数保持一致
is
l_num number default 0;
l_hex varchar2(26) default 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';---------自定意进制的Format
begin
for i in 1 .. length(p_str) loop
l_num := l_num * p_from_base + instr(l_hex,upper(substr(p_str,i,1)));
end loop;
return l_num;
end to_azTdec;

-----2. 转化值

 select To_aztdec('Z'),to_aztdec('V') FROM DUAL

  得到的结果：26,22