Hi,
I am spooling the output of a table to excel file. I am using the below spooling commands:
set pages 20000
set lines 9999
set markup html on;
spool RECIPE_LINK_F3.xls
select * from RECIPE_LINK;
spool off;
set markup html off
exit
But doing so, some of the text column data gets changed to DATE format.in the excel file. Any idea why this happens, and what is the best way to ensure that the data does not change when it is spooled into excel file.
I cannot specify each column in my select statement as I have many tables and each of them have many different columns.
Please let me know what is the best way to get the correct data out into excel file?
Thanks!