SELECT TRIM(trailing 'W' FROM 'WhaT is tHis a W') FROM DUAL
结果:“WhaT is tHis a ”,删除字符串结尾为‘W’的字符
SELECT TRIM(leading 'W' FROM 'WhaT is tHis a W') FROM DUAL
结果:“haT is tHis a W”,删除字符串头部为‘W’的字符
SELECT TRIM(both 'W' FROM 'WhaT is tHis a W') FROM DUAL
结果:“haT is tHis a ”,删除字符串头和尾为‘W’的字符