CHR Function in Oracle SQL – PLSQL

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:

SELECT CHR('97')
FROM dual;

Will return ‘a’

SELECT CHR (65)
FROM dual;

Will return ‘A’

SELECT CHR (98)
FROM dual;

Will return ‘b’


Tagged , , , , , , , , , , , . Bookmark the permalink.