--替换成回车 Select Replace('abcdba','b', chr(13) ) From dual --替换掉回车 Select Replace(带回车的字符串,chr(13) ,'' ) From dual