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.
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 示例六:在银行转帐时经常看见账户人只显示...
55.Oracle数据库SQL开发之 高级查询——使用TRANSLATE函数 欢迎转载,转载请标明出处:http://blog.csdn.net/notbaron/article/details/49805769 TRANSLATE(x,from_string,to_string)函数在x中查找from_string中的字符,并将其转换成to_string中对应的字符。
1.translate 语法:TRANSLATE(char, from, to) 用法:返回将出现在from中的每个字符替换为to中的相应字符以后的字符串。 若from比to字符串长,那么在from中比to中多出的字符将会被删除。 三个参数中有一个是空,返回值也将是空值。 举例:SQL> select translate('abcdefga','abc','wo') 返回值 from dual; ...
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 … - Selection from Oracle PL/SQL Programming, T
Oracle offers a comprehensive and fully integrated stack of cloud applications and cloud platform services.
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. ...
This will ask to Oracle to validate the PL/SQL that could have been invalidate after a export/import for example. The 'VALID' or 'INVALID' status applies to functions, procedures, packages and user defined types. It also concern disabled triggers. EXPORT_INVALID If the above configuration ...