| Can I create an XLS file from SQL*Plus? [message #361306] |
Tue, 25 November 2008 19:00  |
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 #361953 is a reply to message #361321] |
Fri, 28 November 2008 13:01  |
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"
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
