Question

如何设置在sqlplus中不以科学计数法显示

Answer 1

设置列的显示格式
col .. format ...
或者用格式化函数：
select to_char(CUST_ID,'fm999999999999999990.99999') from inter.Pboss_Customer a
where a.customer_number ='977100002098201066';