INSTR: Look for the second occurrence of 'is'
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>
Related examples in the same category