isnumeric function from mysql to oracle

isnumeric : is predefined function in mysql to check if the value data type is number.


but what if you need to check the value is number in oracle Use :

LENGTH(TRIM(TRANSLATE(, ' +-.0123456789', ' '))) is null

Simple

Osama mustafa

Comments

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET