从SQL中导数到ORACLE显示科学计数法
SQL 中是BIGINT类型,
ORACLE中对应的字段是NUMBER(20)插入到ORACLE中显示的是1.12441012100001E15SQL里面是 1124410121000013怎么转换可以正常显示
SQL 中是BIGINT类型,
ORACLE中对应的字段是NUMBER(20)插入到ORACLE中显示的是1.12441012100001E15SQL里面是 1124410121000013怎么转换可以正常显示
tony@ORCL2> select 1124410121000013 from dual;1124410121000013
----------------
1.1244E+15tony@ORCL2> select to_char(1124410121000013) from dual;TO_CHAR(1124410121000013)
--------------------------------
1124410121000013