The team wants my scripts to spool to one log file so it is easier to verify. I found the following from Oracle Forum.
For UNIX or Linux.
spool temp.txt
your_sql;
spool off
host cat temp.txt >> your_file.txt
host rm temp.txt
For Windows.
spool temp.txt
your_sql;
spool off
host type temp.txt >> your_file.txt
host del temp.txt
Subscribe to:
Post Comments (Atom)
Added more to my mindmap tool
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the...
-
This essay version allows you to add long essays to each topic. https://www.free-mindmap.com/Mindmap4LawSchoolEssay.html As I promised, the... -
prompt ==================================================== prompt == Start of check_cursor.sql prompt ===================================...
-
Which two are true about the Automatic Database Diagnostic Monitor (ADDM)? (Choose two.) A. It analyzes a period of time corresponding to ...
No comments:
Post a Comment