Oracle PL/SQL/Char Functions/CHR

CHR() function returns a character corresponding to the number passed in as the argument

 
SQL>
Syntax: CHR(<numeric_code> [USING NCHAR_CS])
SQL>
SQL> SELECT
  2    CHR(65)   "DB_CS",
  3    CHR(65 USING NCHAR_CS)   "N_CS"
  4  FROM dual;
D N
- -
A A

select chr(71)||chr(114)||chr(111)||chr(111)||chr(118)||chr(121) "Cool!"

 
SQL>
SQL>
SQL> select chr(71)||chr(114)||chr(111)||chr(111)||chr(118)||chr(121) "Cool!"
  2  from dual;
Cool!
------
Groovy
1 row selected.
SQL>
SQL> --