Instr Function Examples

Example 1

PL/SQL query
select instr('Oracle Froms tutorial', 'e') from dual;
Result: '6'
select instr('Oracle Froms tutorial', 'e',1,1) from dual;
Result: '6'
select instr('Oracle Froms tutorial', 'a',1,2) from dual;
Result: '20'
select instr('Oracle Froms tutorial', 'a',-5,1) from dual;
Result: '3'