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
Related examples in the same category