也许您正在寻找十进制->十六进制转换？

with data (n) as (
values (90)
union  all
select n + 1
from   data
where  n < 100
),
    alphabet (a) as (
values ('0123456789ABCDEF')
),
    dechex (orig,n,hx) as (
select n, n / 16,cast(substr(a,mod(n, 16) + 1, 1) as varchar(10))
from   data
cross  join alphabet
union  all
select orig,n / 16,substr(a,mod(n, 16) + 1, 1) concat hx
from   dechex
cross  join alphabet
where  n > 0
)
select orig,hx
from   dechex 
where  n = 0
order  by orig