字符串“7.2085E+10”如何转化为number见题目[解决办法]select to_number(substr(7.2085E+10,1,instr(7.2
字符串“7.2085E+10”如何转化为number
见题目
[解决办法]
select to_number(substr('7.2085E+10',1,instr('7.2085E+10','E',1)-1) ) *
power(10,to_number(substr('7.2085E+10',instr('7.2085E+10','+',1)))) from dual