Re: does string contain a valid number

From: Martin Berger <martin.a.berger@xxxxxxxxx>
To: michaeljmoore@xxxxxxxxx
Date: Tue, 18 Aug 2009 20:26:10 +0200

use to_number and fetch the exception, if any?

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

thanks,
Mike


--
//www.freelists.org/webpage/oracle-l

References:
- does string contain a valid number
  - From: Michael Moore

Other related posts:

» does string contain a valid number- Michael Moore
» Re: does string contain a valid number - Martin Berger
» Re: does string contain a valid number- Debaditya Chatterjee
» Re: does string contain a valid number- Adric Norris
» Re: does string contain a valid number- Michael Moore