Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

The underlying database datatype for this example is Unicode UTF-8

SQL> DECLARE   2   3     x CHAR(30 CHAR) := 'The character ?is two-bytes.';   4  BEGIN   5     --Find the location of "is" in terms of characters   6     DBMS_OUTPUT.PUT_LINE(INSTR(x,'is'));   7   8     --Find the location of "is" in terms of bytes   9     DBMS_OUTPUT.PUT_LINE(INSTRB(x,'is'));  10  END;  11  / PL/SQL procedure successfully completed. SQL>