Char Functions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Char Functions
  4. 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