Character String Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Character String Functions
  4. INSTR returns a location within the string where search pattern begins
SQL>
SQL> SELECT INSTR('This is a test','is')FROM dual
  2  /
INSTR('THISISATEST','IS')
-------------------------
                        3
SQL>