title: how to save oracle SQL queries automatically when a query is executed?
body: <p>I want to save SQL/PLSQL queries, which are being executed by a user. </p>
  
  <p>I use the below, and have to use <code>append</code> at the end of the statement as well as saving at the beginning. But, it's headache to execute a save statement all the time after a query is executed. </p>
  
  <p>I'd like to know if there is there any command that would automatically save the queries to the file.</p>
  
  <pre><code>    SQL&gt; save C:\savesueryfolder\first.sql;
      SQL&gt; select * from emp;
      SQL&gt; save C:\savesueryfolder\first.sql append;
  </code></pre>