TO_NCHAR(x) converts x in the database character set to an NVARCHAR2 string.
TO_NCHAR(x)
NVARCHAR2
SQL> select TO_NCHAR('asdfasdf') from dual; TO_NCHAR -------- asdfasdf SQL>