Re: Find last occurance of character

In article <429e2e09.1175744687_at_localhost>, NetComrade says...
> is there a way (using oracle functions) to find last occurance of
> character w/o writing a recursive function?
>
> e.g. select XXXX('ooozo','o') from dual
> would return 5
>
>

SELECT INSTR('ooozo','o',-1) FROM dual;

-- 

jeremy