title: update multiple records in multiple nested tables in oracle
body: <p>I have an oracle table with nested tables in some of the columns. Now, I need to be able to update all the records in each nested table, in each of the records of the main table. How is this accomplished? Any of the ways that I've tried, I get errors about either not be able to perform updates on that view, or single row subquery returns more than one row. </p>
  
  <p>here's an example from    to illustrate. I can run an update like this:</p>
  
  <pre><code>    UPDATE TABLE(select entity.name
                   from entity
                   where entity.uidn = 2)
      SET last = 'Decepticon',
      change_date = SYSDATE,
      change_user = USER
      WHERE first = 'Galvatron';
  </code></pre>
  
  <p>but in this case, the table clause is being executed on a single nested table from a single row. How would an update like this be performed if you didn't want just the entity.uidn which equalled 2?</p>
  
  <p>thanks!</p>