Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 143 of 177
to_nchar_number::=
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.
SELECT TO_NCHAR(customer_id) "NCHAR_Customer_ID" FROM orders WHERE order_status > 9; NCHAR_Customer_ID ----------------- 102 103 148 149 148
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|