Oracle Plsql Nchr Function
Oracle / PLSQL: NCHR Function
This Oracle tutorial explains how to use the Oracle/PLSQL NCHR function with syntax and examples.
Description
The Oracle/PLSQL NCHR function returns the character based on the number_code in the national character set.
Syntax
The syntax for the NCHR function in Oracle/PLSQL is:
NCHR( number_code )Parameters or Arguments
- number_code
The NUMBER code in the national character set used to retrieve the character.
Returns
The NCHR function returns a string value.
Note
The NCHR( number_code ) is the same as using the CHR function with the USING NCHAR_CS clause as follows:
CHR ( number_code USING NCHAR_CS )Applies To
The NCHR function can be used in the following versions of Oracle/PLSQL:
- Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Example
Let's look at some Oracle NCHR function examples and explore how to use the NCHR function in Oracle/PLSQL.
For example:
NCHR(116)
Output: 't'
NCHR(84)
Output: 'T'