This content has been marked as final. Show 2 replies
sqlplus /nolog < mysqplus.sqlWhere mysqlplus.sql contains:
set echo on;Which is resulting in the following echo'ed to stdout:
select count(*) from mytable;
SQL*Plus: Release 18.104.22.168.0 Production on Wed May 25 20:06:17 2011How do I get the executed sql echo'ed as well? In other words, I would like the sql:
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> SQL> Connected.
SQL> SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 22.214.171.124.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing option
select count(*) from mytable;echo'ed to stdout just before it is executed. I thought the option:
set echo on;would do the trick... but it didn't. Any help would be greatly appreciated.