Created On:  12 October 2011

Problem:

User wishes to capture output of SQL queries run in SQL Plus into a text file.  These queries would be performed on a database table in Modernization Workbench during a troubleshooting process with SupportLine.

Resolution:

User can use the "spool" feature to capture output results of a SQL query in SQLPlus into a text file.  Prior to running any SQL query, user must enable the spool feature and specify a target text file.  From here, run the SQL query.  After that, spool must be disabled.

spool C:\log.txt
select * from WorkspaceSettings;
spool off
Incident #2537476