UNISTR() accepts a string argument and returns its representation in a national character set.
SQL> Syntax: UNISTR(<string_expression>) SQL> SQL> SELECT 2 UNISTR('OE ' || '\00C4\00E9') diff 3 FROM dual; DIFF ----- OE -T SQL>