title: How to auto-redefine view when underlying table changes (new column)?
body: <p>We've got a view that's defined like this</p>
  
  <pre><code>CREATE VIEW aView as 
  SELECT * from aTable Where &lt;bunch of conditions&gt;;
  </code></pre>
  
  <p>The "value" of the view is in the where-condition, so it is okay to use a <code>Select *</code> in this case.</p>
  
  <p>When a new column is added to the underlying table, we have to redefine the view with a </p>
  
  <pre><code>CREATE OR REPLACE FORCE VIEW aView as 
  SELECT * from aTable Where &lt;bunch of conditions&gt;;
  </code></pre>
  
  <p>as the <code>Select *</code> seems to get "translated" into all the columns present at the time the view is (re-)defined. </p>
  
  <p>My question: How can we avoid this extra step? 
  (If the answer is dependent on the RDBMS, we're using Oracle.)</p>