Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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