Character String Functions Oracle PLSQL Tutorial

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