Oracle有没有这样一个函数

Question

将1.000003E7(varchar2类型)转换成10000030(varchar2)?

Answer 1

select to_char(to_number('1.000003E7')) from dual;TO_CHAR(TO_NUMBER('1.000003E7'))
--------------------------------
10000030 

Answer 2

  1* select to_number('1.000003E7'),cast(to_number('1.000003E7') as varchar2(20)) from dual
SQL> /TO_NUMBER('1.000003E7') CAST(TO_NUMBER('1.00
----------------------- --------------------
               10000030 10000030

Answer 3

--to_number转换成数字number型后在用cast进行类型转换成varchar2
cast(to_number('1.000003E7') as varchar2(20)) 

Answer 4

select to_char(to_number('1.000003E7')) from dual;结果
          10000030