PLSQL | NCHR Function

Last Updated : 25 Sep, 2019

The PLSQL NCHR function is used for returning the character based on the number code in the national character set or in other words it returns the binary equivalent to the number in the national character set. The value returned by the NCHR function is always of the datatype NVARCHAR2.

The NCHR function is equivalent to using the CHR function with the USING NCHAR_CS clause. The parameter passed to the NCHR function takes a NUMBER as an argument, or any value that can be implicitly converted to NUMBER, and returns a character.

Syntax:

NCHR(number_code)

Parameters Used:

number_code – It is used to specify the NUMBER code in the national character set used to retrieve the character.

Supported Versions of Oracle/PLSQL:

Oracle 12c
Oracle 11g
Oracle 10g
Oracle 9i
Oracle 8i

Example-1:

DECLARE      Test_value int := 103;       BEGIN      dbms_output.put_line(NCHR(Test_value));        END;

Output:

Example-2:

DECLARE      Test_value int := 103;       BEGIN      dbms_output.put_line(CHR(Test_value USING NCHAR_CS));        END;

Output

Example-3:

DECLARE      Test_value int := 187;       BEGIN      dbms_output.put_line(NCHR(Test_value));        END;

Output:

»

PLSQL | INSTRB Function

Shubrodeep Banerjee

Improve

Article Tags :

Similar Reads

PLSQL | LN Function

The LN function is an inbuilt function in PLSQL which is used to return the natural logarithm of a given input number. The natural logarithm of a number is the logarithm of that number to the base e, where e is the mathematical constant approximately equal to 2.718. This is written using the notatio

2 min read

PLSQL | INSTRC Function

The PLSQL INSTRC function is used for returning the location of a substring in a string, Unicode complete characters. The PLSQL INSTRC function searches a string for a substring specified by the user using characters and returns the position in the string that is the first character of a specified o

2 min read

PLSQL | INSTR4 Function

The PLSQL INSTR4 function is used for returning the location of a substring in a string using UCS4 code points. UCS-4 codepoints is a character encoding which allows the representation of each value as exactly four bytes (one 32-bit word). UCS-4 represents a possible value between 0 and hexadecimal

3 min read

PLSQL | INSTRB Function

The PLSQL INSTRB function is used for returning the location of a substring in a string, using bytes instead of characters. The PLSQL INSTRB function searches a string for a substring specified by the user using characters and returns the position in the string that is the first character of a speci

2 min read

PLSQL | LENGTH4 Function

The PLSQL LENGTH4 function is used for returning the length of the specified string, using UCS4 code points. UCS-4 codepoints is a character encoding which allows the representation of each value as exactly four bytes (one 32-bit word). UCS-4 represents a possible value between 0 and hexadecimal 7FF

2 min read

PLSQL | LOWER Function

The PLSQL LOWER function is used for converting all letters in the specified string to lowercase. If there are characters in the string that are not letters, they are unaffected by this function. The char to be converted can be any of the datatypes such as CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or

1 min read

PLSQL | MOD Function

The MOD function is an inbuilt function in PLSQL which is used to return the remainder when a is divided by b. Its formula is [Tex]m - n * \left\lfloor\dfrac{m}{n}\right\rfloor[/Tex]. Syntax: MOD(a, b) Parameters Used: This function accepts two parameters a and b. This function gives remainder as th

2 min read

PLSQL | LOG Function

The PLSQL LOG function is used for returning the logarithm of n base m. The LOG function accepts two parameters which are used to calculate the logarithmic value. The LOG function returns a value of the numeric data type. This function takes as an argument any numeric data type as well as any non-nu

2 min read

PL/SQL Functions

PL/SQL functions are reusable blocks of code that can be used to perform specific tasks. They are similar to procedures but must always return a value. A function in PL/SQL contains:Function Header: The function header includes the function name and an optional parameter list. It is the first part o

4 min read

PLSQL | LEAST Function

The LEAST is an inbuilt function in PLSQL which is used to return the least value from a given list of some expressions. These expressions may be numbers, alphabets etc. Syntax: LEAST(exp1, exp2, ... exp_n) Parameters Used: This function accept some parameters like exp1, exp2, ... exp_n. These each

2 min read