Ascii gives the ASCII value of the first character of a string : ASCII « Character String Functions « Oracle PL/SQL Tutorial






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

The general format for this function is: ASCII(string)

SQL>
SQL> SELECT ASCII('first') FROM dual;

ASCII('FIRST')
--------------
           102








11.2.ASCII
11.2.1.ASCII(x) gets the ASCII value of the character x
11.2.2.Ascii gives the ASCII value of the first character of a string
11.2.3.ASCII(0), ASCII(9)
11.2.4.select ascii('a'), ascii('z'),ascii('A'), ascii('Z'),ascii('ABC'), chr(77)
11.2.5.ASCII('A') ASCII('Z') ASCII('A') ASCII('Z') ASCII('ABC')