title: SQLPLUS saving to file
body: <p>I have to use SQLPLUS for my database class, and our first assignment is simple saving.</p>
  
  <p>I followed the instructions.. (I'm using PuTTY to access sqlplus)</p>
  
  <p>"Use the following SQL commands in this exercise and try the SAVE and SPOOL commands to save your SQL commands and output to external files.</p>
  
  <pre><code>select table_name from all_tables where owner='UNIVERSITY';
  select * from university.faculty;
  select * from university.clubs;
  </code></pre>
  
  <p>For this lab, do the following:</p>
  
  <ul>
  <li><p>At the SQL> prompt, type <code>Save test.sql</code> (or <code>save test.sql replace</code> if the file already exists) then hit <kbd>enter</kbd>; then type any SQL commands, the commands will be saved to the test.sql file. Later you can use the START command to run the saved SQL commands. E.g.:
  SQL> start test.sql</p></li>
  <li><p>At the SQL> prompt, type <code>spool output.txt</code> then <kbd>enter</kbd>; then type any SQL commands; when finished type 'spool off'; the commands and results will be saved to file output.txt. The file will be overwritten if used in the spool command again. Turn in file <code>test.sql</code> and <code>output.txt</code> in the dropbox on D2L by Monday before class."</p></li>
  </ul>
  
  <p>(Obviously asking for help isn't against the rules, since the instructions are right there already.. i simply don't understand them or they're wrong)</p>
  
  <p>When I type SAVE test.sql i yield => "Nothing to save"</p>
  
  <p>When I type SAVE test.sql after a query, it saves only the last typed query.</p>
  
  <p>How do I have it save ALL my queries instead of just the last one typed?</p>