本文共 1274 字,大约阅读时间需要 4 分钟。
translate(x, from_string, to_string) - ?????from_string???to_string translate('SECRET MESSAGE: MEET ME IN THE PARK', 'ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ', 'EFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCD') ????: WIGVIX QIWWEKI: QIIX QI MR XLI TEVO translate('WIGVIX QIWWEKI: QIIX QI MR XLI TEVO', 'EFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCD', 'ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ') ????: SECRET MESSAGE: MEET ME IN THE PARK ???????Oracle?????translate?????????
translate?????????????????????????????Oracle????????????????
?????
translate('????', '???1', '???2')
- ?????????????
- ???1?????
- ???2?????
????
1. translate?????????????
2. ?????????????????????
3. ?????????????????????NULL
4. translate??????dual_dual?????
??1?
translate('SECRET MESSAGE: MEET ME IN THE PARK', 'ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ', 'EFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCD')
????: WIGVIX QIWWEKI: QIIX QI MR XLI TEVO
??2?
translate('WIGVIX QIWWEKI: QIIX QI MR XLI TEVO', 'EFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZABCD', 'ABCDEFGHIJKLMNOPQRSTUVWXYZABCDEFGHIJKLMNOPQRSTUVWXYZ')
????: SECRET MESSAGE: MEET ME IN THE PARK
???????????translate???????????????????????Oracle?????????????
转载地址:http://wlpfk.baihongyu.com/