CHR(x) gets the character with the ASCII value of x : CHR « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. CHR

CHR() and ASCII() have the opposite effect.

The following example gets the characters with the ASCII value of 97, 65, 122, 90, 48, and 57 using CHR().

SQL> SELECT CHR(97), CHR(65), CHR(122), CHR(90), CHR(48), CHR(57) FROM dual;

C C C C C C
- - - - - -
a A z Z 0 9

SQL>








11.3.CHR
11.3.1.CHR(x) gets the character with the ASCII value of x
11.3.2.Use CHR() function to create special char