Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL NCHR Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: NCHR

Definition:
The Oracle PL/SQL function NCHR returns character of NVARCHAR2 type corresponding to the input ASCII code, which is passed as parameter. Its output can be noted as the reverse of the ASCII function in Oracle.

Example Syntax:

NCHR(number)


Example Usage:

The query below returns the character equivalent of ASCII code 65.

SQL> SELECT NCHR(65) FROM DUAL;

A
-


The query below shows the reverse path of ASCII code 65 using the ASCII function.

SQL> SELECT ASCII(NCHR(1)) FROM DUAL;

ASCII(NCHR(A))
--------------
65



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 68 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?