CHR() function returns a character corresponding to the number passed in as the argument : CHR « Char Functions « Oracle PL / SQL






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

 








Related examples in the same category

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