The Oracle judgment value is not a number, and the Oracle judgment value is a number
Select * from product_info t where t. contract_detailid is not nulland length (translate (t. contract_detailid ,'-. 0123456789 '| t. contract_detailid ,'-. 0123456789 ') <> length (t. contract_detailid) for update
Determine and delete non-numbers in the oracle database
Create test table
Create table test (col varchar2 (100); insert into test values ('2017-123 '); insert into test values ('2017-00 '); insert into test values ('2014 ()');
Running statement
Select translate (col, '0' | translate (col, '#0123456789', '#'), '0') from test
Result
Oracle determines whether the value of a field is a number.
To determine whether all fields of the simplified type are composed of numbers, you can use the translate function or regular expression to determine whether a complex type field is a numerical value. For 10 Gb, you can use a regular expression.