Oracle equivilant for the 'isnumeric' function ...

[TomSalvato]

Hello all,

is there an 'isnumeric' funtion that I can use in an SQL expression field?

I basically need to say something like this ...

using a crystal psuedo-code ...

(
select max ("table.desiredfield")
from "db"."table"
where isnumeric("table"."stringfield" )
)

-TS

 

[kray4660]

A quick search showed this link. I have not tested the code.

http://www.techonthenet.com/oracle/questions/isnumeric.php