|
|
|
|
Re: Want sql output in xls format [message #310683 is a reply to message #310649] |
Wed, 02 April 2008 01:18   |
cherry
Messages: 56 Registered: December 2007
|
Member |
|
|
I used to
set markup html on spool on
--specify a file with extension htm or html
spool c:\ex1.html
--your query
select * from dept;
--end the html file
spool off
--set back to normal output
set markup html off spool off
SET VERIFY OFF;
SET SERVEROUTPUT ON SIZE 1000000;
SPOOL file_name.txt;
select * from table;
SPOOL OFF;
But you already are spooling into XL. Per my knowledge, its not possible to return formatted result, unless you use some other language like PERL to do so.
Try using other tools to export (ex Toad, Sql developer).
@ the end you should remember, SqlPlus is not a reporting tool.
|
|
|
Re: Want sql output in xls format [message #310684 is a reply to message #310649] |
Wed, 02 April 2008 01:19   |
cherry
Messages: 56 Registered: December 2007
|
Member |
|
|
I used to
set markup html on spool on
--specify a file with extension htm or html
spool c:\ex1.html
--your query
select * from dept;
--end the html file
spool off
--set back to normal output
set markup html off spool off
SET VERIFY OFF;
SET SERVEROUTPUT ON SIZE 1000000;
SPOOL file_name.txt;
select * from table;
SPOOL OFF;
But you already are spooling into XL. Per my knowledge, its not possible to return formatted result, unless you use some other language like PERL to do so.
Try using other tools to export (ex Toad, Sql developer).
@ the end you should remember, SqlPlus is not a reporting tool.
|
|
|
|
|