Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Character String Functions

 

If search pattern is not in the string, the INSTR function returns 0

SQL> SQL> SELECT INSTR('This is a test','abc',1,2)FROM dual   2