摘要：
最近数据处理时经常发现有数字中含有大量字符，执行过程报“ORA-01722:invalidnumber”异常，可以有一下几种方法去除：1、replace 用法简单，写法较复杂，只能处理已知字符 With test_table1 As ( Select 1 seq_num, '2134?654?ag d35' strings From dual Union All Select 2 seq_num, '651 354a g5 dd21' strings From dual ) Select seq_num, Replace(Replace(Replace(Repl 阅读全文
