SELECT TRANSLATE('2KRW229', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '0123456789') "Translate example" FROM DUAL 罗勇补充示例如下: 示例三:示例证明是按照字符来处理,不是按照字节来处理,如果to_string的字符数比from_string多的话,多出的字符数似乎没有什么用处,也不会引发异常。 SELECT TRANSLATE('我是中...
1.TRANSLATE这个函数的格式:TRANSLATE ( '原本的值','需要被替换的值','替换后的值') 2.便于理解的例子: 例子A(‘原本的值’中如果有值不存在于‘需要被替换的值’,不存在于‘替换后的值’)的查询效果: 1 SELECTTRANSLATE ('ABCDEFGH','ABCDEFG','1234567')ASNEW_STRFROMDUAL; 转换思路('需要被替换的...
SELECT TRANSLATE('I am Chinese, I love China', 'China', '中国') "Translate example" FROM DUAL 示例五:以下示例证明,如果第二个参数为空字符串,整个返回null。 SELECT TRANSLATE('2KRW229', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ', '') "License" FROM DUAL 示例六:在银行转帐时经常看见账户人只显示...
SELECT TRANSLATE('2KRW229','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ','9999999999XXXXXXXXXXXXXXXXXXXXXXXXXX') "License"FROM DUAL 示例二:将数字保留,将其他的大写字母移除。 SELECT TRANSLATE('2KRW229','0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ','0123456789') "Translate example"FROM DUAL 罗勇补充示例如下: 示例三...
Sql代码 1. SELECT TRANSLATE('abcdefghij','abcdef','123456') FROM dual;2. TRANSLATE (3. --- 4. 123456ghij 5.6. SELECT TRANSLATE('abcdefghij','abcdefghij','123456') FROM dual;7. TRANSL 8. --- 9. 123456 语法：TRANSLATE(expr,from,to)expr: 代表⼀串字符，from 与 to 是从左到右...
55.Oracle数据库SQL开发之 高级查询——使用TRANSLATE函数 欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/49805769 TRANSLATE(x,from_string,to_string)函数在x中查找from_string中的字符,并将其转换成to_string中对应的字符。
函数用法都不一样，translate是逐个字符替换的 --包含ABC则替换为123 SELECT REPLACE('AbCaBc','ABC','123') FROM dual;--将A替换成1，B替换成2，C替换成3 SELECT TRANSLATE('AbCaBc','ABC','123') FROM dual;
In theTO_CHARfunction to translate aDATEvalue that is in a format other than the default date format into a string (for example, to print the date from an application) The total length of a date format model cannot exceed 22 characters. ...
Oracle PL/SQL Programming, Third Edition by Buy on Amazon Name TRANSLATE...USING Synopsis This function exists to provide ANSI compatibility, and translates character data between character sets. Because TRANSLATE . . . USING is so unusual, we provide the syntax for using it, rather than its ...
Oracle BAM Server has been implemented as an Oracle Data Integrator technology (for example, DB2, SQL Server are Oracle Data Integrator technologies) and Oracle BAM has Oracle Data Integrator knowledge modules which let Oracle Data Integrator perform all of the operations on Oracle BAM Server to ...