Oracle9i SQL Reference
Release 1 (9.0.1)

Part Number A90125-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Functions, 72 of 166


NCHR

Syntax

nchr::=


Text description of functions127a.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 

Example

The following examples return the nchar character 187:

SELECT NCHR(187) FROM DUAL;

NC
--
> 

SELECT CHR(187 USING NCHAR_CS) FROM DUAL;

CH
--
> 

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback