Oracle SQL: the Essential Reference

TRANSLATE USING

TRANSLATE(text USING {CHAR_CS | NCHAR_CS})

Converts text into the database character set or the national character set.

Parameters

text

Specifies a string that you want to translate.

CHAR_CS

Causes the string to be converted from the national character set into the database character set. The result is returned as a VARCHAR2 value.

NCHAR_CS

Causes the string to be converted from the database character set into the national character set. The result is returned as an NVARCHAR2 value.

Example

SQL> SELECT TRANSLATE('Be Nice' USING NCHAR_CS)
  2  FROM dual;

TRANSLA
-------
Be Nice