Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
to_nchar_number::=
Purpose
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
, TIMESTAMP
WITH
TIME
ZONE
, TIMESTAMP
WITH
LOCAL
TIME
ZONE
, INTERVAL
MONTH
TO
YEAR
, or INTERVAL
DAY
TO
SECOND
datatype.
Examples
The following example converts the customer_id
values from the sample table oe.orders
to the national character set:
SELECT TO_NCHAR(customer_id) "NCHAR_Customer_ID" FROM orders WHERE order_status > 9; NCHAR_Customer_ID ----------------- 102 103 148 149 148