Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. Look for the second occurrence of is
SQL>
SQL> SELECT INSTR('This is a test','is',1,2)FROM dual
  2  /
INSTR('THISISATEST','IS',1,2)
-----------------------------
                            6
SQL>