Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

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

SQL> SQL> SQL> -- 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; INSTR('THISISATEST','ABC',1,2) ------------------------------                              0