Home Oracle How to store all SQL commands / Output (spooling) in oracle?
How to store all SQL commands / Output (spooling) in oracle? PDF Print E-mail
Written by Siva   
Tuesday, 23 November 2010 00:12


Use SPOOL followed by path and filename.

SQL*Plus: Release - Production on Wed Jun 8 09:12:36 2005


Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.



Connected to:

Oracle9i Enterprise Edition Release - 64bit Production

With the Partitioning, OLAP and Oracle Data Mining options

JServer Release - Production


SQL> set pagesize 1024


SQL> spool c:\sql\capture_all.txt


SQL> Spool off



Featured Links:
Looking for job? Try HREmail.com
Want to have CMS based Websites?
Try siliconwebcreators.com to CMS based websites.
VM Solutions Inc
For best VM solutions..
Digital Procedure Inc.
Looking for Oracle /SAP /Weblogic Consulting services? visit digitalprocedure.com