SELECT LTRIM('xyxXxyLAST WORD','xy') "LTRIM example"
FROM DUAL;LTRIM example
------------
XxyLAST WORDSELECT RTRIM('BROWNINGyxXxy','xy') "RTRIM example"
FROM DUAL;
RTRIM examp
-----------
BROWNINGyxX
FROM DUAL;LTRIM example
------------
XxyLAST WORDSELECT RTRIM('BROWNINGyxXxy','xy') "RTRIM example"
FROM DUAL;
RTRIM examp
-----------
BROWNINGyxX
FROM DUAL;TRIM Example
------------
98723489
trim的区别是语法有点复杂,
TRIM
( [{ { LEADING | TRAILING | BOTH } [trim_character])
| trim_character
}
FROM
]
trim_source
)
可以从左边截取——leading
从右截取——trailing
左右都截——both
缺省是both
的結果為什麼是
ppi呢?