UNISTR
The UNISTR function takes as its argument a string that resolves to data of type NVARCHAR2 and returns the value in UTF-16 format. Unicode escapes are supported. You can specify the Unicode encoding value of the characters in the string.
                  
SQL syntax
UNISTR ('String')Parameters
UNISTR has the parameter:
                  
| Parameter | Description | 
|---|---|
| 
 | The string passed to the  | 
Examples
The following example invokes the UNISTR function passing as an argument the string 'A\00E4a'. The value returned is the value of the string in UTF-16 format:
                  
Command> SELECT UNISTR ('A\00E4a') FROM dual;
<Aäa> 1 row found.