title: Create a trigger that updates a column on one table when a column in another table is updated
body: <p>i have two tables</p>
  
  <p>Order(id, date, note)</p>
  
  <p>and</p>
  
  <p>Delivery(Id, Note, Date)</p>
  
  <p>I want to create a trigger that updates the date in Delivery when the date is updated in Order.</p>
  
  <p>I was thinking to do something like </p>
  
  <pre><code>CREATE OR REPLACE TRIGGER your_trigger_name
  BEFORE UPDATE
  ON Order
  DECLARE
  BEGIN
     UPDATE Delivery set date = ??? where id = ???
  END;
  </code></pre>
  
  <p>How do I get the date and row id?</p>
  
  <p>thanks</p>