Проверка на число

select case when str is null then 'number' else 'not number' end
from (
select translate('0495756', '_0123456789', '_') str from dual
)



select case when translate('049575f6', '_0123456789', '_') is null then cast('049575f6' as number) else null end  from dual