摘要： RT 阅读全文

摘要： 1.在oracle中，一般是把一个字符串从一种编码类型转换成另一种编码类型 http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/functions023.htm#sthref1160 CONVERT Syntax convert::= CONVERT(char, dest_char_set[, source_char_set ])Purpose CONVERT converts a character string from one character set to another. The d... 阅读全文

摘要： 两种表示，都是一样的 1.TRIM([ { (LEADING | TRAILING | BOTH)[ trim_character ] | trim_character } FROM ] trim_source )2. trim([leading | trailing | both] trim_char from string)For example:trim(' tech ') would return 'tech' trim(' ' from ' tech ') would return 'tech' trim 阅读全文