SQL> select * from A; ID NAME --------------------------------------- -------------------- 1 one,two,threeSQL> select id,replace(name,',','|') from A; ID REPLACE(NAME,',','|') --------------------------------------- --------------------- 1 one|two|three
--------------------------------------- --------------------
1 one,two,threeSQL> select id,replace(name,',','|') from A; ID REPLACE(NAME,',','|')
--------------------------------------- ---------------------
1 one|two|three
replace 函数的用法:
replace('将要更改的字符串','被替换掉的字符串','替换字符串')