Skip Headers

Oracle® Database SQL Reference
10g Release 1 (10.1)

Part Number B10759-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

NCHR


Syntax

nchr::=
Description of nchr.gif follows
Description of the illustration nchr.gif


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.


See Also:

CHR


Examples

The following examples return the nchar character 187:

SELECT NCHR(187) FROM DUAL;

NC
--
> 

SELECT CHR(187 USING NCHAR_CS) FROM DUAL;

CH
--
>