引自http://www.itpub.net/thread-1164262-1-1.html
select trim('|' FROM replace('|' || str1 || '|', '|' || str2 || '|', '|')) str
from (select '1|2|3|4' str1, '2' str2 from dual);
select replace('|' || str1 || '|', '|' || str2 || '|', '|') str
from (select '1|2|3|4' str1, '2' str2 from dual);
SELECT TRIM('|' FROM '|1|2|3|4|5|6|7|') FROM DUAL;
最后一句。。。。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/65190/viewspace-598195/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/65190/viewspace-598195/