如何设置在sqlplus中不以科学计数法显示
查询语句:
select * from inter.Pboss_Customer a
where a.customer_number ='977100002098201066';
查询结果:
CUST_ID customer_number
7.0000E+13 977100002098201066
如何设置在sqlplus中不以科学计数法显示?谢谢!
------解决方案--------------------select to_char(CUST_ID,'fm999999999999999990.99999') from inter.Pboss_Customer a
where a.customer_number ='977100002098201066';
------解决方案--------------------设置列的显示格式
col .. format ...