Oracle 19c SQL

  1. Home
  2. Docs
  3. Oracle 19c SQL
  4. Single Row Character Functions
  5. ASCII

ASCII

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;
Was this article helpful to you? Yes No

How can we help?