Multiple choice technology databases

select instr('Hi Partha Sarathi Ojha','a',5) from dual; The o/p would be...

  1. 5

  2. 9

  3. 22

  4. 0
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

INSTR searches for 'a' starting at position 5. The string is 'Hi Partha Sarathi Ojha'. Characters at positions 5 is the 'a' in 'Partha' (H-i- -P-a). The first 'a' from position 5 is at position 5 itself, so it returns 5.

Keep practicing — related questions