Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
Purpose
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.
Examples
The following examples return the nchar character 187:
SELECT NCHR(187) FROM DUAL; NC -- > SELECT CHR(187 USING NCHAR_CS) FROM DUAL; CH -- >