Oracle equivalent of IsNumeric in SQLServer

Dear folks,

In Transact-SQL (SQLServer 7/2000), there's a function called IsNumeric to determine whether an expression is a valid numeric type or not.

For instance, "SELECT ISNUMERIC("No Number")" will return 0 (false), and "SELECT ISNUMERIC(123)" or "SELECT ISNUMERIC("123")" will return 1 (true).

Is there a similar function in Oracle SQL?

Deecay Received on Thu Aug 29 2002 - 10:11:04 CDT