ORACLE -----TRIM函数 

两种表示，都是一样的
  1. 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(leading '0' from '000123')   would return '123'
trim(trailing '1' from 'Tech1')   would return 'Tech'
trim(both '1' from '123Tech111')   would return '23Tech'

posted @ 2010-11-12 03:17  0707  阅读(187)  评论(0)  编辑  收藏  举报