Can we export data from sqlplus into excel format.
I've tried it with spool file given name *.xls but the values falls under one column.
Here i need a solution to export each columns of table into different columns of excel sheet.
Thanks in advance !!
Yes you can do that in very simple way ..
Just give SET MARKUP HTML ON SPOOL ON and do remaining as usual give path for spooling ..
example spool d:/filename.xls and do your executions ..
It will arrange automatically in columnwise ..
Try and let me know if it helped you ...