开发者

replace function in dml statements in oracle 8i

开发者 https://www.devze.com 2022-12-26 14:34 出处:网络
Can we use Replace() function in an update statement ? If yes then how? I have a column enrollno having values like \'800-00001\' to \'800-01800\'.

Can we use Replace() function in an update statement ? If yes then how?

I have a column enrollno having values like '800-00001' to '800-01800'. I want to replace initial '800-' to '800' in all 1800 records. (Output should be '8000001' to '80001800')

Is it possible through replace function or any other option is th开发者_如何转开发ere in ORACLE8i ?

MaheshA...


update table set col = replace(col,'800-','800')
0

精彩评论

暂无评论...
验证码 换一张
取 消