The CHR function in Oracle SQL / PLSQL is used to get the character from the ASCII value code. CHR function is basically opposite of the ASCII function in Oracle SQL / PLSQL
Syntax for the CHR Function in Oracle SQL / PLSQL is:
SELECT CHR (ascii_number)
FROM table_name;
Examples:
Using CHR function in Oracle SQL / PLSQL SELECT statement:
1 | SELECT CHR( '97' ) |
2 | FROM dual; |
Will return ‘a’
1 | SELECT CHR (65) |
2 | FROM dual; |
Will return ‘A’
1 | SELECT CHR (98) |
2 | FROM dual; |
Will return ‘b’