This is giving me a headache! I can't seem to spool any csv files where the number field length is greater than 11 digits. For example 1.23832E+11 should actually be 123831961495
Is there anything that can be changed in the below that will prevent scientific notation?
COLUMN dcol new_value mydate noprint
Alter session set nls_date_format='dd/mm/yyyy hh24:mi:ss';
column normalised_event_id format '99999999999999999';
column charge_id format '99999999999999999';
SELECT to_char(sysdate+1,'YYYYMMDD') dcol FROM dual;
spool \\three\departments\rabillsourcecode\RA_Dropzone\Data_Cap_Usage_&mydate..csv;
set linesize 10000;
set pagesize 0;
set colsep ,;
set trimout on;
set trimspool on;
set term off;
set numw 14;
SET NEWPAGE NONE;
Thanks for any help you can provide!