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.
CHR( number_code )
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
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;