Re: does string contain a valid number
From: Debaditya Chatterjee <debaditya.chatterjee_at_gmail.com>
Date: Tue, 18 Aug 2009 14:33:24 -0400
Message-ID: <90f8af090908181133o77e6dc10i24ce2779a47747cd_at_mail.gmail.com>
You can use regular expressions to validate
Date: Tue, 18 Aug 2009 14:33:24 -0400
Message-ID: <90f8af090908181133o77e6dc10i24ce2779a47747cd_at_mail.gmail.com>
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_at_gmail.com>wrote:
> What is the best way to see if a string contains a valid number? 10gR2
>
> thanks,
> Mike
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 18 2009 - 13:33:24 CDT