SQL ASCII() Function

SQL ASCII() Function return the ASCII values of given argument.

SQL ASCII() Function supported Oracle SQL version

Oracle 8i
Oracle 9i
Oracle 10g
Oracle 11g
Oracle 12c
Oracle 18c

Syntax

ASCII(character)

Parameter

character is single character that return ASCII value of given character.

Example

Considering following example SQL ASCII function.

SQL> SELECT ASCII('J') FROM DUAL;

ASCII('J')
----------
        74

SQL> SELECT ASCII('E') FROM DUAL;

ASCII('E')
----------
        69

SQL> SELECT ASCII('M') FROM DUAL;

ASCII('M')
----------
        77