Oracle PL/SQL/Char Functions/UNISTR

unistr("\0300")

   
SQL>
SQL>
SQL> select unistr("\0300") from dual;
`
1 row selected.
SQL>

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>

UNISTR(x): Converts the characters in x to the national language character set (NCHAR)

 
SQL>
SQL> --UNISTR(x): Converts the characters in x to the national language character set (NCHAR).
SQL>
SQL> SELECT UNISTR("abc\00e5\00f1\00f6") FROM DUAL;
UNISTR
------
abcåñ
SQL>
SQL>