Re: Find last occurance of character

On Wed, 01 Jun 2005 21:54:47 GMT, netcomradeNSPAM_at_bookexchange.net (NetComrade) wrote:

>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

 Use INSTR.

http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10759/functions058.htm#SQLRF00651

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool