读取的数据中的字符串,再截取后几位,转换int+1

Question

数据库读取的是字符串怎么加1
例如是adasd109 
这个字符串加+1怎么写 会变成adasd110

Answer 1

SELECT    TRANSLATE
             ('adasd109',
              '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',
              'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'
             )
       || TO_char
             (  TRANSLATE
                   ('adasd109',
                    '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz',
                    '0123456789'
                   )
              + 1
             )
  FROM DUAL

Answer 2

select substr('adasd109',1,5)                     --取前几位
       ||trim(                                     --去掉 to_char后产生的空格
               to_char(                             --把加1后的数值转换成字符
                to_number(substr('adasd109',6))+1,
               '0999')
         )
from dual