Home » SQL & PL/SQL » Client Tools » Can I create an XLS file from SQL*Plus?
Can I create an XLS file from SQL*Plus? [message #361306] Tue, 25 November 2008 19:00 Go to next message
wmgonzalbo
Messages: 98
Registered: November 2008
Member
Hi, im currently using TOAD.. just want to ask does SQL * PLUS has also a 'tool' for processing the output tables to excel file (.xls) automatically?

Would like to try SQL * PLUS too..

Thanks,
Wilbert
Re: Export data into excel file [message #361321 is a reply to message #361306] Tue, 25 November 2008 23:16 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Plus does not provide such a tool.

Regards
Michel
Re: Export data into excel file [message #361953 is a reply to message #361321] Fri, 28 November 2008 13:01 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Two easy ways to get sqlplus output into excel...
CSV:
spool my_dat.csv
set colsep ","
set pagesize 0
select 'xyz', 123, sysdate from dual;
spool off

HTML cut & paste:
set markup html on
spool my_dat.html
set pagesize 100
select 'xyz', 123, sysdate from dual;
spool off

Open output file in a browser, select all and copy & paste into Excel.

For a PL/SQL solution, you can google "owa_sylk"
Re: Export data into excel file [message #362244 is a reply to message #361953] Mon, 01 December 2008 07:49 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Tom Kyte has a package called OWA_SYLK that creates output in a format that Excel spreadsheets can import.
Previous Topic: problems with TOAD
Next Topic: sql*plus only works for user oracle
Goto Forum:
  


Current Time: Sat Dec 03 20:40:18 CST 2016

Total time taken to generate the page: 0.10222 seconds