Get Ascii value of the character in oracle

By Santhosh N

This explains how to get the ascii code of the desired character in oracle.

Oracle has a function by the name, ASCII used to get the ascii code of the given character.

Syntax: ASCII (char)

Ex: select ASCII (ā€˜sā€™) from dual;
      This returns 115 as the result.

Note: This returns the ascii code of only one character and even though if entered more than one character, it gives the ascii code of the first entered character only

Related FAQs

There are four types of Datatypes for date in oracle including the support to the time and timezone info alongwith daylightsavings time where applicable
Oracle has a function to give the position of the char or string inside the string
What is the real purpose of dual in oracle.
Used to check if the column value is in numeric format
Get Ascii value of the character in oracle  (3010 Views)