Question

oracle如何将截取出来的一个字符串的数字自身加1?这是我截取出来的：1101010,加1后要成为:1101011

Answer 1

那你意思是这个字符串是字符型
那就
select to_number(substr(字段,1,7)) + 1 from 表名

先截取，截取完了转成数字型，然后+1

追问

我是这样截取的：SELECT substr(StudentNo, 2, lengthb(StudentNO)) FROM Student WHERE StudentNO like '%S1%' ORDER BY StudentNo DESC，像我这样怎么样转成数字型，然后+1呢？

Answer 2

SELECT to_number(substr(StudentNo, 2, lengthb(StudentNO)))+1 FROM Student WHERE StudentNO like '%S1%' ORDER BY StudentNo DESC

Answer 3

SELECT substr(StudentNo, 2, lengthb(StudentNO))
改成
SELECT to_number(substr(StudentNo, 2, lengthb(StudentNO)))