Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

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>