博客
关于我
Oracle中Transate函数的使用
阅读量:792 次
发布时间:2023-02-25

本文共 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/

你可能感兴趣的文章