SQL> --INSTR: returns a location within the string where search pattern begins.SQL>SQL>SQL> SELECT INSTR('This is a test','is') FROM dual;INSTR('THISISATEST','IS')------------------------- 3SQL>SQL>