Re: regexp_like weirdness in 10G?

From: Vladimir M. Zakharychev <>
Date: Sun, 14 Feb 2010 13:46:46 -0800 (PST)
Message-ID: <>

On Feb 14, 11:55 pm, Ken Quirici <> wrote:
> I'm getting this column contents (the column is a varchar2(200)):
> 'K+CS2(26)/DP'
> matched by this:
> regexp_like(<col-name>,'^(\d)+\(B|\d\).*DP.*')
> Just in case, I also returned the column length and got 12, which is
> exactly the number of
> characters between the single quotes.
> I thought '^' meant start-of-string, in this case, start-of-database-
> column-string, so I
> should not be getting a match with a string starting with 'K+CS'>
> When I remove the '^' I get exactly the same results.
> I'm running this test in TOAD.

Unless the booze really got hold of me, your RE says: either "^(\d)+\ (B" or "\d\).*DP.*". "\d\).*DP.*" (a digit followed by literal ")", then at least one character, then literal "DP", then at least one character - note that end-of-line counts as a character here) perfectly matches the input.

RE is not for the faint-hearted. In fact, you need to be very precise in what you're after...


   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm) Received on Sun Feb 14 2010 - 15:46:46 CST

Original text of this message