请教高手

Question

有一字段，是字符型的。如下：JK00000001，JK00000002等
我现在要把后面的数字统一的增加1，就是JK00000001－>JK00000002  JK00000002->JK00000003
请高人给我写个语句。多谢谢！！

Answer 1

tryselect substr('JK00000001',1,2)||lpad((substr('JK00000001',3)+1),8,'0') from dual

Answer 2

SQL> select * from test_09;A
--------------------
JK00000001
JK00000002SQL> update test_09 set a=substr(a,1,2)||lpad(to_number(substr(a,3,8))+1,8,'0');已更新2行。SQL> select * from test_09;A
--------------------
JK00000002
JK00000003

Answer 3

UPDATE tableName Set column1=concat(substr(column1,1,2),LPAD(substr(column1,3,8)+1,8'0');

Answer 4

drop table tb1;
create table tb1(jk varchar(20));
insert into tb1(jk)values('JK00000001');
insert into tb1(jk)values('JK00000002');
commit;
select substr(jk,0,9)||(substr(jk,10,1)+1) from tb1;