TO_NCHAR (number)

Syntax

to_nchar_number::=

Text description of to_nchar_number

Purpose

The TO_NCHAR (number) function converts a number to a string in the NVARCHAR2 character set. The optional fmt and nlsparam corresponding to n can be of DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE, INTERVAL MONTH TO YEAR, or INTERVAL DAY TO SECOND datatype.

Example

SELECT TO_NCHAR(CUSTOMER_ID) "NCHAR_Customer_ID"  FROM ORDERS 
   WHERE ORDER_STATUS > 9 
  
NCHAR_Customer_ID 
-----------------
102 
103 
148 
149 
148