TO_NCHAR (number)

TO_NCHAR (number) converts n to a string in the national character set. The value n can be of type NUMBER, BINARY_FLOAT, or BINARY_DOUBLE. The function returns a value of the same type as the argument. The optional fmt and 'nlsparam' corresponding to n can be of DATE, TIMESTAMP, TIMESTAMPWITHTIMEZONE, TIMESTAMPWITHLOCALTIMEZONE, INTERVALMONTHTOYEAR, or INTERVALDAYTOSECOND datatype.

Examples

The following example converts the customer_id values from the sample table oe.orders to the national character set: