81,092
社区成员
发帖
与我相关
我的任务
分享
select flag
,((case when length(to_char(flag))=1 then 'CMK00'
when length(to_char(flag))=2 then 'CMK0'
else 'CMK' end)||flag) as res
from (
select (TO_NUMBER(substr('CMK001',4))+1) as flag
from dual
)
name(流水号名字) currvalue(当前值)
XF20101022 3
FK201010 4