Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

INSTR returns a location within the string where search pattern begins

SQL> SQL> SELECT INSTR('This is a test','is')FROM dual   2  / INSTR('THISISATEST','IS') -------------------------                         3 SQL>