MarkView All Components - How do I spool from SQL*Plus to Excel?
4012
Summary
4012
Applies To
- ERP System: All
- MarkView Version: All
Resolution
- You can spool to Microsoft Excel by using "spool" followed by the pathname for the new file.
For example:
SQL> set pages 1000 SQL> set lines 1000 SQL> set trimspool on SQL> spool c:\fax_data.xls SQL> select * from mv_fax_request; SQL> select * from mv_fax_request_history; SQL> select * from markview.mv_document where document_id = 330072; SQL> spool off
Keywords: sql, plus, SQL*Plus, Excel