Want to search character 'a' from last in the string 'Hi Partha Sarathi Ojha'. So what would be the query...
select instr('Hi Partha Sarathi Ojha',last,'a') from dual
select instr('Hi Partha Sarathi Ojha','a',-1) from dual
select instr('Hi Partha Sarathi Ojha',left,'a') from dual
select instr('Hi Partha Sarathi Ojha',-1,'a') from dual
select instr('Hi Partha Sarathi Ojha','-a') from dual