SELECT INSTR('BANANA AND ANANAS','AN',2,3) FROM DUAL; SELECT INSTR('BANANA AND ANANAS','A',1,2) FROM DUAL; SELECT INSTR('BANANA AND ANANAS','AN',3,2) FROM DUAL ...
select phone_number, substr(phone_number, instr(phone_number, '.', 1,1)+1, instr(phone_number, '.', 1,2)-instr(phone_number, '.', 1,1)) melumat from hr.employees ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback