Hi,
Just wondering whether is it possible to turn off the command that we enter on SQL Plus?
For example, I do something as below.
sqlplus test/test@testdb
SQL*Plus: Release 10.2.0.4.0 - Production on Wed Oct 5 15:16:09 2011
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> set termout on
SQL> spool test2.log
SQL> select sysdate from dual;
SYSDATE
---------
05-OCT-11
SQL> spool off
I tried to set termout on but it seems doesn't help here.
cat test2.log
SQL> select sysdate from dual; <<< How can I remove this line?
SYSDATE
---------
05-OCT-11
SQL> spool off <<< How can I remove this line?
Thanks.