September 2002
Intermediate to advanced
1024 pages
30h 52m
English
NCHR
NCHR functions similarly to CHR, but returns a value from the national language character set. The specification is:
FUNCTION NCHR(code_location NUMBER) RETURN NVARCHAR2;Values returned by NCHR should generally be assigned to NVARCHAR2 or NCHAR2 variables. To do otherwise is to force a character set conversion that you probably don’t need. Following is an example of using NCHR:
DECLARE x NVARCHAR2(30); BEGIN x := NCHR(65); ...
The CHR function’s USING NCHAR_CS clause provides the same functionality as NCHR.
Read now
Unlock full access