title: How can I do this dynamical update in Oracle?
body: <p>I have the model table defined like:</p>
  
  <pre><code>MODEL (id NUMBER, capacity NUMBER ) 
  </code></pre>
  
  <p>and the flight table defined like:</p>
  
  <pre><code>FLIGHT (flight_number NUMBER, available_seats NUMBER)
  </code></pre>
  
  <p>I want to initialize the available_seats field in FLIGHT with the capacity number defined in MODEL each time a new row is inserted in FLIGHT table. Also I want to notify the user when the available_seats counts down to zero. How can I do this? </p>