Re: does string contain a valid number

From: Debaditya Chatterjee <debaditya.chatterjee@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Tue, 18 Aug 2009 14:33:24 -0400

You can use regular expressions to validate

  1* Select 1 from dual where regexp_like ('SomeString100and','[0-9]')
SQL> /

         1
----------
         1
  1* Select 1 from dual where regexp_like ('SomeString','[0-9]')
SQL> /

no rows selected

Thanks

Debaditya Chatterjee


On Tue, Aug 18, 2009 at 2:19 PM, Michael Moore <michaeljmoore@xxxxxxxxx>wrote:

> What is the best way to see if a string contains a valid number? 10gR2
>
> thanks,
> Mike
>

References:

does string contain a valid number
From: Michael Moore

Re: does string contain a valid number

Other related posts: