oracle的 replace函數的用法
3 回答
翻過高山走不出你
TA貢獻1875條經驗 獲得超3個贊
SELECT REPLACE('JACK and JUE','J','BL') "Changes"
FROM DUAL;
Changes
--------------
BLACK and BLUE
人到中年有點甜
TA貢獻1895條經驗 獲得超7個贊
replace( string1, string_to_replace, [ replacement_string ] )
For example:
replace('123123tech', '123'); would return 'tech'
replace('123tech123', '123'); would return 'tech'
replace('222tech', '2', '3'); would return '333tech'
replace('0000123', '0'); would return '123'
replace('0000123', '0', ' '); would return ' 123'
添加回答
舉報
0/150
提交
取消