Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

ASCII(x) gets the ASCII value of the character x

CHR() and ASCII() have the opposite effect. The following example gets the ASCII value of a, A, z, Z, 0, and 9 using ASCII(). SQL> SELECT ASCII('a'), ASCII('A'), ASCII('z'), ASCII('Z') from dual; ASCII('A') ASCII('A') ASCII('Z') ASCII('Z') ---------- ---------- ---------- ----------         97         65        122         90 SQL>