This content has been marked as final. Show 3 replies
The HOST command writes a separate output that is printed on sqlplus screen but is ignored by the spool command.
The only workaround I can suggest you is the following:
SQL> host date > a.txt -- Doing this outside the spool SQL> spool a.txt append -- append mode not to loose the previous content of the file SQL> select 1 from dual; 1 ---------- 1 SQL> spool off SQL> host cat a.txt Tue Jan 26 17:20:12 CET 2010 SQL> select 1 from dual; 1 ---------- 1 SQL> spool off SQL>
[My Italian Oracle blog|http://oracleitalia.wordpress.com/2010/01/23/la-forza-del-foglio-di-calcolo-in-una-query-la-clausola-model/]