Instr, substring

INSTR( string, substring [, start_position [, th_appearance ] ] )

select instr('bba', 'a') from dual;
-- 3

select instr('a', 'a') from dual;
-- 1


select instr('a', 'b') from dual;