Oracle PL/SQL Ascii Function
The Ascii Function returns the NUMBER code that represents the specified character.
The Ascii Function syntax:
ascii ( character )
If more than one character is entered, the function acii will return only the value for the first character.
select ascii('a') from dual; would return 97 select ascii('A') from dual; would return 65 select ascii('A7') from dual; would return 65