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