截取字段并转为ascii 博客分类： oracle ascii
程序员文章站
2024-03-21 18:41:46
...
select t.STAT_ID,
ASCII(substr(t.STAT_ID,1,1))||ASCII(substr(t.STAT_ID,2,1))||ASCII(substr(t.STAT_ID,3,1))||ASCII(substr(t.STAT_ID,4,1))
from XXX t