TO_NCHAR (number)

Syntax

to_nchar_number::=

Text description of to_nchar_number

Purpose

TO_NCHAR (number) 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.

Examples

SELECT TO_NCHAR(customer_id) "NCHAR_Customer_ID"  FROM orders 
   WHERE order_status > 9;
  
NCHAR_Customer_ID 
-----------------
102 
103 
148 
149 
148