MarkView All Components - How do I spool from SQL*Plus to Excel?

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