The Oracle ASCII function returns the NUMBER that represents the specified character.

The specified character to retrieve the NUMBER code for. If more than one character is entered, the ASCII function will return the value for the first character and ignore all of the characters after the first.

SELECT ASCII('d') Result FROM DUAL;

SELECT ASCII('D') Result FROM DUAL;

SELECT ASCII('dcodeman') Result FROM DUAL;