Oracle ASCII function

Preamble

The Oracle/PLSQL ASCII function returns the numeric representation of the leftmost character of the string.

Syntax of the Oracle/PLSQL ASCII function

ASCII( single_character_id )

• single_character_id – symbol for getting a numeric code. If more than one character is passed, the ASCII function will return a value for the first character and ignore all subsequent characters.

The ASCII function returns a numeric value.

ASCII function in the following versions of Oracle/PLSQL

Let’s consider some examples of the ASCII function and learn how to use the ASCII function in Oracle PLSQL.

SQL> SELECT ASCII('a') FROM DUAL;
--Result: 97

SQL> SELECT ASCII('t') FROM DUAL;
--Result: 116

SQL> SELECT ASCII('T') FROM DUAL;
--Result: 84

SQL> SELECT ASCII('T2') FROM DUAL;
--Result: 84.

SQL> SELECT ASCII('%') FROM DUAL;
--Result: 37

SQL> SELECT ASCII('A') FROM DUAL;
--Result: 65

ASCII Function in SQL Query with Example

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​