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
>

Other related posts: