PL/SQL Ascii

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.

Example:

select ascii('a') from dual;

would return 97


select ascii('A') from dual;

would return 65


select ascii('A7') from dual;

would return 65