在8.0中找不到TRIM()这个函数,只能找到ltrim,rtrim这两个函数 http://download-west.oracle.com/docs/cd/A58617_01/server.804/a58225/ch3all.htm#998335LTRIM Syntax LTRIM(char [,set]) Purpose Removes characters from the left of char, with all the leftmost characters that appear in set removed; set defaults to a single blank. Oracle begins scanning char from its first character and removes all characters that appear in set until reaching a character not in set and then returns the result. Example SELECT LTRIM('xyxXxyLAST WORD','xy') "LTRIM example" FROM DUAL;LTRIM exampl ------------ XxyLAST WORD
http://download-west.oracle.com/docs/cd/A58617_01/server.804/a58225/ch3all.htm#998335LTRIM
Syntax
LTRIM(char [,set])
Purpose
Removes characters from the left of char, with all the leftmost characters that appear in set removed; set defaults to a single blank. Oracle begins scanning char from its first character and removes all characters that appear in set until reaching a character not in set and then returns the result.
Example
SELECT LTRIM('xyxXxyLAST WORD','xy') "LTRIM example"
FROM DUAL;LTRIM exampl
------------
XxyLAST WORD