How to get value of N specified character in Oracle


In Oracle CHR returns the character having the binary equivalent to n as a VARCHAR2 value in either the database character set or, if you specify USING NCHAR_CS, the national character set.
This function takes as an argument a NUMBER value, or any value that can be implicitly converted to NUMBER, and returns a character. The syntax for the CHR function is:  CHR(N)

For Example:

SELECT CHR(83) FROM DUAL;
RESULT: S

SELECT CHAR(115) FROM DUAL;
RESULT: s



Comments

Popular posts from this blog

How to create Oracle stored Procedures using TOAD for Oracle

Create Tables in Oracle Database using TOAD

How to Create Packages in Oracle Database using TOAD for Oracle