TO_NCHAR(character) converts a character string to the national character set.
NVARCHAR2
TO_NCHAR(exp)
exp is a text expression. If it contains characters that are not represented in the national character set, then the conversion results in a loss of data.
TO_NCHAR( 'David Ortiz') returns the value David Ortiz in the national character set.
Copyright © 2003, 2007, Oracle. All rights reserved.