into dom_data_value
(companyid, useno, datano, datavalue, datatime, indexclass)
select companyid, useno, datano, to_number(datavalue), datetime, indexclass from dom_src_report where datano <>'G105' AND datano <>'G108'dom_data_value datavalue 是number 理性dom_src_report 是字符类型 从A表的字符字段转换数据插入到B表的数字字段
(companyid, useno, datano, datavalue, datatime, indexclass)
select companyid, useno, datano, to_number(datavalue), datetime, indexclass from dom_src_report where datano <>'G105' AND datano <>'G108'dom_data_value datavalue 是number 理性dom_src_report 是字符类型 从A表的字符字段转换数据插入到B表的数字字段
Name Type Nullable Default Comments
---- ------------ -------- ------- --------
ID INTEGER Y
NAME VARCHAR2(20) Y
SQL> insert into t values(to_number('23'),'王五');
1 row inserted
SQL> commit;
Commit complete
SQL> select * from t;
ID NAME
--------------------------------------- --------------------
1 kkkk
1 kkkk
23 王五
SQL>
如果报错的话,可能是to_number(datavalue)里有非数字
是不是存在非数字的字符