Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: REGEXP_like

Re: REGEXP_like

From: Mladen Gogala <mgogala.SPAM_ME.NOT_at_verizon.net>
Date: Sat, 28 Apr 2007 01:57:37 GMT
Message-ID: <pan.2007.04.28.01.57.37@verizon.net>


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.com
Received on Fri Apr 27 2007 - 20:57:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US