Skip Headers

Oracle9i SQL Reference
Release 2 (9.2)

Part Number A96540-02
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 Go to next page
View PDF

NCHR

Syntax

nchr::=

Text description of functions130.gif follows
Text description of nchr


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.

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