<pre name="code" class="sql">SQL> SELECT TRANSLATE('ab你好bcadefg', '1abcdefg', '1') AS NEW_STR FROM DUAL;
NEW_
----
你好
--按字母排序
SQL> set linesize 200
SQL> select data, translate(data,'-0123456789','#') from v order by 2;
DATA TRANSLATE(DATA,'-0123456789','#')
--------------------------------------------------- ------------------------------------------------------------------------------------------------------
ADAMS 7876 ADAMS
ALLEN 7499 ALLEN
BLAKE 7698 BLAKE
CLARK 7782 CLARK
FORD 7902 FORD
JAMES 7900 JAMES
JONES 7566 JONES
KING
利用translate函数去掉指定字符
最新推荐文章于 2022-10-29 14:57:02 发布