SQL> select trim('s' from 'string') from dual;TRIM( ----- tring以上是在8I中测试。不知道楼主问的是什么?
SQL> select trim('t' from 'test') from dual;TRIM('T'FROM'TEST') ------------------- es SQL> select translate('test','t',' ') from dual;TRANSLATE('TEST','T','') ------------------------ esSQL>
select trim('s' from 'string') from dual; 可以没有问题. 你什么版本.
SQL> select trim('t' from 'test') from dual;TR -- esSQL> select trim('z' from 'zzy') from dual;T - y 完全可以啊!
trim()可以去掉两头的字符,但不能去掉中间的 如果想去掉任意位置的可以用translate() SQL> select translate('string','i',' ') from dual;TRANSLATE('S ------------ str ngSQL> select translate('string','i',chr(0)) from dual;TRANSLATE( ---------- strngSQL> select translate('stringtest','s',chr(0)) from dual;TRANSLATE('STRIN ---------------- tringtet
-----
tring以上是在8I中测试。不知道楼主问的是什么?
-------------------
es
SQL> select translate('test','t',' ') from dual;TRANSLATE('TEST','T','')
------------------------
esSQL>
可以没有问题.
你什么版本.
--
esSQL> select trim('z' from 'zzy') from dual;T
-
y
完全可以啊!
如果想去掉任意位置的可以用translate()
SQL> select translate('string','i',' ') from dual;TRANSLATE('S
------------
str ngSQL> select translate('string','i',chr(0)) from dual;TRANSLATE(
----------
strngSQL> select translate('stringtest','s',chr(0)) from dual;TRANSLATE('STRIN
----------------
tringtet