Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: regexp_substr occurrences problem
Vladimir M. Zakharychev wrote:
> > All I get is |DEF| when I think I should get |GHI| as well. Where am I
> > going wrong?
> >
> > Phil Hibbs.
>
> No, you shouldn't. Since |DEF| matched, search continues *past* it, and
> next goes GHI|JLK, not |GHI|JLK - the pipe preceding G is kept with the
> previous match. The regexp is not a sliding window into the string.
Yes, I came to that conclusion myself yesterday afternoon. I challenge your definition of "should", though. Sure, in Oracle's implementation, that's what you get, but that isn't standard regular expression behaviour in my experience.
Phil Hibbs. Received on Tue Sep 19 2006 - 05:30:54 CDT