Archive

Posts Tagged ‘isnumber number’

isNumber function in oracle

August 10, 2010 Leave a comment

As we don’t have an isNumber function in oracle, if you want to know which values are not numbers, just type this:

select field from table where translate(field, '_0123456789', '_') is not null;
Categories: oracle, script Tags: