PLSQL | CHR Function
The string in PL/SQL is actually a sequence of characters with an optional size specification.
The characters could be numeric, letters, blank, special characters or a combination of all.
The CHR Function in PLSQL is the opposite of the ASCII function and is used to return the character based on the NUMBER code.
Syntax:
CHR( number_code )
Parameters Used:
number_code – It is used to retrieve the character for the specified number code.
Supported Versions of Oracle/PLSQL:
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
- Oracle 8i
Example:
DECLARE
Test_Char varchar2(4) := '69';
Test_Char1 varchar2(4) := '72';
BEGIN
dbms_output.put_line(CHR(Test_Char));
dbms_output.put_line(CHR(Test_Char1));
END;
Output:
E H
Recommended Posts:
- PLSQL | EXP Function
- PLSQL | LN Function
- PLSQL | ABS Function
- PLSQL | COS Function
- PLSQL | SIN Function
- PLSQL | LOG Function
- PLSQL | LEAST Function
- PLSQL | TAN Function
- PLSQL | MOD Function
- PLSQL | CEIL Function
- PLSQL | TRUNC Function
- PLSQL | BITAND Function
- PLSQL | SUBSTR Function
- PLSQL | FLOOR Function
- PLSQL | TRANSLATE Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.



