Skip to main content

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



Applies To

  • ERP System: All
  • MarkView Version: All


  • 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