oracle 11gr2 官方介绍地址:
http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions216.htm#SQLRF06145 基本语法:translate(expr,from_string,to_string) translate 就是一个字符级别的替换: 如下所示: SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production CORE
Link URL: http://www.yafeishi.net/blog/2012/07/oracle-function-translate.html
Link URL: http://www.yafeishi.net/blog/2012/07/oracle-function-translate.html
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23008765/viewspace-735615/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/23008765/viewspace-735615/