Purpose
You can call this function to convert text literals and Unicode encodings into strings in the national character set.
A Unicode encoded value is in the \xxxx format, where xxxx is a hexadecimal value (UCS-2 code unit) of a character in UTF-16-encoded format. If the string itself includes a backslash, add another backslash (\\) before it.
Syntax
UNISTR(string)
Parameters
The string parameter is a string of any character set.
Return types
This function returns a string value.
Examples
Convert ASCII and Unicode encoded values to strings of the national character set.
obclient> SELECT UNISTR('A B C \FF20 \00C4 \00CA \00CD \00D5 \00D8') FROM DUAL;
+---------------------------------------------+
UNISTR('ABC\FF20\00C4\00CA\00CD\00D5\00D8')
+---------------------------------------------+
A B C ＠ Ä Ê Í Õ Ø
+---------------------------------------------+
1 row in set