Get the character of the Ascii code in oracle

By Santhosh N

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

Oracle has a function by the name, CHR which is used to get the character of the ascii code passed.

Syntax: CHR(n)

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

Note: This is exactly opposite to the ASCII function.

Related FAQs

This explains how to convert any character set strings to ascii character set strings in oracle.
This explains how to get the ascii code of the desired character in oracle.
Oracle has a function to give the position of the char or string inside the string
Oracle provides a simple function to find and replace null values with the predefined values in select statements
What is the real purpose of dual in oracle.
Used to check if the column value is in numeric format
Get the character of the Ascii code in oracle  (2920 Views)