chr()函数将ASCII码转换为字符;
ascii()函数将字符转换为ASCII码; 在oracle中chr()函数和ascii()是一对反函数。
chr()函数示例:
SQL> select chr(65) from dual;
CHR(65) ------- A
accii()函数示例:
SQL> select ascii('A') from dual;
ASCII('A') ---------- 65
转载于:https://blog.51cto.com/3891779/911754