Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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>