title: How to spool a number in oracle in correct format
body: <p>I am trying to spool the records by executing script in SqlDeveloper, everything is working fine except printing the record of columns which are NUMBER(38,0) data type.</p>
  
  <p>All numbers record are printing in below format:</p>
  
  <p><strong><code>1.5E+18</code></strong></p>
  
  <p>I tried many combinations by using set but nothing working.</p>