PLSQL | NCHR Function

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:

  1. Oracle 12c
  2. Oracle 11g
  3. Oracle 10g
  4. Oracle 9i
  5. Oracle 8i

Example-1:

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

Output:

g 



Example-2:

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

Output

g



Example-3:

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

Output:

» 


My Personal Notes arrow_drop_up

I am a technology enthusiast who has a keen interest in programming I am pursuing Engineering in Computer Science from GEU, Dehradun I like to unwind by watching movies and English sitcomsI have a keen interest in music

If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to contribute@geeksforgeeks.org. See your article appearing on the GeeksforGeeks main page and help other Geeks.

Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.




Article Tags :
Practice Tags :


Be the First to upvote.


Please write to us at contribute@geeksforgeeks.org to report any issue with the above content.