Oracle SQL - SQL*Plus number width

Introduction

If you anticipate having numbers with more than five digits, you must use a number higher than 5.

If numwidth is at least 7, Oracle will display the number in exponential format

set numwidth 6

select 123456789123456789 num from DUAL; 

   NUM 
------ 
###### 

set numwidth 7 

/ 

    NUM 
------- 
1.2E+17 

Related Topics