Oracle PL/SQL/Char Functions/CHR

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

   <source lang="sql">

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

</source>
   
  

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

   <source lang="sql">

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> --

</source>