----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