Oracle中Transate函数的使用-白红宇的个人博客

Oracle中Transate函数的使用

发布日期：2025-04-30 00:14:24 浏览次数：15 分类：精选文章

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

上一篇：oracle中关于日期问题的汇总！

下一篇：oracle中sql的case语句运用--根据不同条件去排序！

发表评论

关于作者

喝酒易醉，品茶养心，人生如梦，品茶悟道，何以解忧？唯有杜康！

-- 愿君每日到此一游！

发表评论

最新留言

关于作者

推荐文章