Press "Enter" to skip to content

How to Get ASCII Value in Oracle?

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: