Re: Need regexp help (seemingly simple problem)
Date: Fri, 23 Oct 2009 12:12:37 -0700
Yes, I was looking for the equiv of Perl look-around functionality.Sorry to hear it's not there. Thanks for the reference. Mike
On Fri, Oct 23, 2009 at 11:53 AM, Rich Jesse < rjoralist_at_society.servebeer.com> wrote:
> Hey Mike,
> > First of all I would like to say that finding detailed information about
> > Oracle's implementation of regular expressions is next to impossible.
> > that, or I am looking in all the wrong places. So, links to any complete
> > online documentation would be appreciated. I found plenty of 'basic
> > explanation' but there has got to be more.
> This site might help:
> ...although it's lacking in version-specific information about what
> implemented. There's also a link at the bottom of the page for a book from
> > I could easily use INSTR and SUBSTR to do this, but my goal is to solve
> > problem using a single REGEXP_SUBSTR statement. Also, I have used the
> > pattern 'a[[:digit:]]+' which results in 'a12345'. This is almost right,
> > I don't want the 'a' to be returned.
> I don't think that's possible with Oracle's regex. It's possible in Perl,
> but only in 5.10 and up from what I've found. This is as close as I could
> select regexp_substr('2B4a12345Z2lr7','[[:digit:]]+',
> from dual;
> Yes, the REGEXP_INSTR is overkill as INSTR would work just as well and is
> most likely faster for this particular use.
> Here's the doc that describes a possible "true" answer in regex, although
> does not appear to be possible in Oracle's regex.