title: Create after insert trigger which updates record by getting value from other Oracle 11g table
body: <p>I have two tables</p>
  
  <pre><code>Parent(id, name, occupation)
  
  Child(id, name, gender,parent_id, parent_name, parent_occupation)
  </code></pre>
  
  <p>Now to insert value in child i'll run chi query</p>
  
  <pre><code>insert into Child(id,name,gender,parent_id) values(10,'XYZ','Male',15);
  </code></pre>
  
  <p>So now my requirement is when this insert query is executed a trigger will run and get name and occupation from parent table for id 15 (parent_id of the Child record) and add it to the newly inserted row in fields parent_name and parent_occupation respectively.</p>
  
  <p>I am using Oracle 11g as my database. </p>