How to Get ASCII Value in Oracle?

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

In Oracle, use ASCII function to get ASCII value of a string.

Syntax

ASCII function takes a single char as an argument and returns the numeric value.

ASCII (char)

Oracle ASCII Function Example

The following example will return ASCII value of a double-quoted string ( " ).

SELECT ASCII ('"') FROM DUAL;

Output

ASCII('"')
----------
34
1 row selected.

See also: