개인적인 정리

[Oracle] NCHR() 본문

DB/ORACLE

[Oracle] NCHR()

yeon.Biju 2020. 4. 10. 10:40

오라클 NCHR()

 

NCHR()

   -

 

NCHR(number)

의 형태

 

NCHR returns the character having the binary equivalent to number in the national character set. The value returned is always NVARCHAR2. This function is equivalent to using the CHR function with the USING NCHAR_CS clause.

 

This function takes as an argument a NUMBER value, or any value that can be implicitly converted to NUMBER, and returns a character. 

 

SQL> SELECT NCHR(187) FROM DUAL ;

   --> »

'DB > ORACLE' 카테고리의 다른 글

[Oralce] NULLIF()  (0) 2020.04.13
[Oracle] NTILE()  (0) 2020.04.13
[Oracle] NTH_VALUE()  (0) 2020.04.10
[Oracle] NEXT_DAY()  (0) 2020.04.10
[Oracle] NANVL()  (0) 2020.04.10
[Oracle] MONTHS_BETWEEN()  (0) 2020.04.10
[Oracle] MOD()  (0) 2020.04.09
[Oracle] MIN()  (0) 2020.04.09
Comments