CHR Function :
Syntax : CHR (number);
CHR (number USING NCHAR_CS)
- In Oracle PL/SQL CHR function returns a ASCII equivalent of the input numeric value that is passed to the function.
- The Function will return a national character if you specify USING NCHAR_CS
Example 1:
SELECT CHR(72)||CHR(69)||CHR(76)||CHR(76)||CHR(79)"RESULT" FROM DUAL;
RESULT
-------
HELLO
Example 2 :
SELECT CHR (50052 USING NCHAR_CS) "RESULT" FROM DUAL;
RESULT
-- ---
Ä