Char Functions Oracle PLSQL

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