1.在查询的where里面加入条件语句,查看异常数据: select*from表名wherenvl2(translate(字段名,'/1234567890','/'),'CHAR','NUMBER')='CHAR' 2.正则表达式函数 REGEXP_SUBSTR 处理,将数据进行过滤,ok! --条件语句:whereREGEXP_SUBSTR(t1.operatorid,'[0-9]+')ISNOTNULL--示例:selectt1.operatorid,t2.eq...
语句本身一看就知道会出问题,因为3没加引号,会被当作数字处理。这样就肯定会报ORA-01722: invalid number的错误:SQL Error: 1722, SQLState: 42000 ORA-01722: invalid number 但在用hibernate时,为了避免数字问题,我们经常会这样写hsql语句:String sql = 'select * from ctEntity as ct where ...
首先ORACLE不可能出现这么简单的BUG;其次就算是BUG,返回的错误提示也不应该是 invalid number。按理说,即使ORACLE不能自动完成类型转换而要求写成 srvclass='9',那么对srvclass=9这种写法的错误提示也应该是invalid character。但由于直觉作怪,也就没有深究 正好有人质疑bug的说法,我就从头进行检查,才发现错误的根本原...
Error is ORA-29913: error in executing ODCIEXTTABLEFETCH callout ORA-01722: invalid number My procedure is very long but am happy to send what I need for someone to assist. Thank you. Gwen
I have an Oracle 10g database, and in it is a table where the first column is a VARCHAR 36 and contains Oracle generated UIDs. I am trying to run a SELECT query that gets a corresponding (date 19) where the UID = '{ a 36 character long UID}'. I am getting the ORA-01722 inval...
From Oracle FAQ Jump to:navigation,search ORA-01722: invalid number Contents [hide] 1 What causes this error? 2 Examples 3 How to fix it 3.1 When doing an INSERT INTO ... VALUES (...) 3.2 When doing a SELECT, rather than an INSERT or UPDATE ...
Oracle Transportation Operational Planning - Version 6.2.0 and later: ORA-01722: invalid number Error Received When Using a Rate Offering Type of "AIR_DISPLAY"
I am getting "Oracle database error 1722: ORA-01722: invalid number" when I am trying to refresh the extracts. I debugged into the issue and found there is a value which is stored as a string in oracle database and I am converting that into numeric value. For example "Result" is ...
when installing extensions Got an error when installing extensions for new Edge Browser Package is invalid...: 'CRX_VERSION_NUMBER_INVALID' Solution Change .c...
ON a.incdno_bin = f.card_bin ; 报错信息: SELECT * ERROR at line 1: ORA-12801: error signaled in parallel query server P003, instance db1:db1 (1) ORA-01722: invalid number 原因分析: 存在将字符和数字进行比较。 解决:a.mobile_code = to_char(b.mobile_code)...