spool off does not give the whole datafrom different fields
Hello
I have an issue with an sql that I have registered and put on server to be executed. I submit a report and it generate a csv file. The issue is that I have quite a lot of data in the fields. They are 4000 bytes. I am concatenating the different fields to be extracted in the csv but the file gives me only part of the data. Could anyone help please.
The coding is as such
select to_char(sysdate,'yyyymmdd')||'.csv' date_column
from dual;
set array 100
set pages 0
set wrap on
set flush off
set feed off
I have an issue with an sql that I have registered and put on server to be executed. I submit a report and it generate a csv file. The issue is that I have quite a lot of data in the fields. They are 4000 bytes. I am concatenating the different fields to be extracted in the csv but the file gives me only part of the data. Could anyone help please.
The coding is as such
select to_char(sysdate,'yyyymmdd')||'.csv' date_column
from dual;
set array 100
set pages 0
set wrap on
set flush off
set feed off
0