title: ORA-38106: MERGE not supported on join view or view with INSTEAD OF trigger
body: <p>How do I merge into a view with multiple tables. 
  My issue is that only when child, parent table join, I can determine the match condition to merge and just with single table I can't.  </p>
  
  <p>I am getting ORA-38106: MERGE not supported on join view or view with INSTEAD OF trigger</p>
  
  <pre><code>create table t (id number, c varchar2(10));
  create table p (p_id number, id number);
  
  merge into (select t.c, p.p_id from t, p  where t.id = p.id) t 
       using (select 1 id from dual) d 
          ON (t.p_id = d.id) 
        when matched then update set c = 'iii';
  </code></pre>