Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. 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> --