title: Is it possible to create a trigger for inserting data of a table on another table in Oracle?
body: <p>I'm learning about Oracle and I have a query, if like says in the title, create a trigger that can insert data from one table into another table. How can I do it? if I have this tables: </p>
  
  <pre><code>create table personal(
      id_person);
  
  create table mine(
      id_mine,
      name_mine,
      pay);
  
  create table trip(
      id_trip,
      id_person,
      name_mine,
      date_trip);
  
  create table assignment(
      id_assig,
      id_trip,
      pay);
  </code></pre>
  
  <p>The column <strong><em>pay</em></strong> in the table <strong><em>assignment</em></strong> is the column that I want to insert automatically from the table <strong><em>mine</em></strong> through the trigger.</p>