Oracle® Database SQL Reference 10g Release 1 (10.1) Part Number B10759-01 |
|
|
View PDF |
NCHR
returns the character having the binary equivalent to number
in the national character set. This function is equivalent to using the CHR
function with the USING
NCHAR_CS
clause.
This function takes as an argument a NUMBER
value, or any value that can be implicitly converted to NUMBER
, and returns a character.
The following examples return the nchar character 187:
SELECT NCHR(187) FROM DUAL; NC -- > SELECT CHR(187 USING NCHAR_CS) FROM DUAL; CH -- >