我想在orcale里 用repalce 可是有下划线,总是报 无效数据key orderno
1-1_ 1
1-2_ 2
1-3_ 3
update T_COMPANY set KEY=REGEXP_REPLACE(KEY,CAST(ORDERNO AS CHAR(2))+'_',CAST(ORDERNO-1 AS CHAR(2))+'_') 希望各位帮我看看怎么解决啊~!
1-1_ 1
1-2_ 2
1-3_ 3
update T_COMPANY set KEY=REGEXP_REPLACE(KEY,CAST(ORDERNO AS CHAR(2))+'_',CAST(ORDERNO-1 AS CHAR(2))+'_') 希望各位帮我看看怎么解决啊~!
Update t1
Set Key = Replace(Key, to_char(orderno), to_char(orderno - 1))
Where orderno = 2;这样不可以么?
不加上'_',还是你有什么需求,必须得加上‘_'
update T_COMPANY set KEY='1-'||to_char(orderno-1)||'_';