Oracle INSTR

The Oracle INSTR functions search string for substring.

Oracle INSTR example

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'