Find the location of '\0303' using INSTRC : Unicode « PL SQL Data Types « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. PL SQL Data Types
3. Unicode

SQL>
SQL> DECLARE
  2     --The underlying database datatype for this example is Unicode UTF-16
  3     x NCHAR(40) := UNISTR('The character a\0303 could be composed.');
  4  BEGIN
  5
  6     DBMS_OUTPUT.PUT_LINE(INSTRC(x,UNISTR('\0303')));
  7
  8     --Find the location of "\0303" using INSTR4
  9     DBMS_OUTPUT.PUT_LINE(INSTR4(x,UNISTR('\0303')));
 10  END;
 11  /

PL/SQL procedure successfully completed.