ORACLE CHECK NUMERIC VALUE QUERY – ORACLE DA SAYI KONTRÖLÜ SORGUSU

SELECT CASE
WHEN LENGTH (TRIM (TRANSLATE (’123412341234′, ‘ +-.0123456789′, ‘ ‘))
) IS NULL
THEN 1
ELSE 0
END is_numeric
FROM DUAL