Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: REGEXP_like
On Fri, 27 Apr 2007 10:09:26 -0700, Vladimir M. Zakharychev wrote:
> select id from my_table where regexp_like(id,'0[0-9]$')
>
> should do the trick.
Even better: regexp_like(id,'0\d$')
That is an old trick learned by an extensive use of pathologically eclectic rubbish lister.
-- http://www.mladen-gogala.comReceived on Fri Apr 27 2007 - 20:57:37 CDT