Oracle NCHR function
Description
The Oracle NCHAR() function is used to get the character having the binary equivalent to the number in the national character set. This function is equivalent to using the CHR function with the USING NCHAR_CS clause.
Syntax:
NCHR(number)
Parameters:
This function takes as an argument a NUMBER value, or any value that can be implicitly converted to NUMBER, and returns a character.
Return Value Type
The value returned is always NVARCHAR2.
Applies to
Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i
Examples: Oracle NCHR function
The following examples return the nchr character against a given number.
SQL> SELECT NCHR(122) FROM DUAL;
N
-
z
SQL> SELECT NCHR(162) FROM DUAL;
N
-
ó
SQL> SELECT NCHR(188) FROM DUAL;
N
-
╝
Previous:
LTRIM
Next:
NLS_INITCAP
- New Content published on w3resource:
- HTML-CSS Practical: Exercises, Practice, Solution
- Java Regular Expression: Exercises, Practice, Solution
- Scala Programming Exercises, Practice, Solution
- Python Itertools exercises
- Python Numpy exercises
- Python GeoPy Package exercises
- Python Pandas exercises
- Python nltk exercises
- Python BeautifulSoup exercises
- Form Template
- Composer - PHP Package Manager
- PHPUnit - PHP Testing
- Laravel - PHP Framework
- Angular - JavaScript Framework
- Vue - JavaScript Framework
- Jest - JavaScript Testing Framework