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
>
> Thanks.
> .......
> We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes
> remove NSPAM to email
Assuming your definition of "last" is Euro-centric": INSTR and search
from the right to left.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Jun 01 2005 - 19:21:16 CDT
