title: Oracle SQL Trigger not getting created
body: <p>I have a table passenger as shown below</p>
  <pre><code>Column       Null?        Type
  ------------------------------------
  NAME          -          VARCHAR2(20)
  ID          NOT NULL     NUMBER
  ADDRESS       -          VARCHAR2(20)
  CHARGES       -          NUMBER
  </code></pre>
  <p>I am learning triggers and I want to create a trigger that updates charges as charges + 100 before a new insert is done. Here is the trigger I created.</p>
  <pre class="lang-sql prettyprint-override"><code>create or replace trigger flight
  before insert on passenger
  for each row
  set new.charges = new.charges + 100;
  /
  </code></pre>
  <p>However, I am getting the error <code>ORA-04079: invalid trigger specification</code>. I have tried replacing <code>new</code> with <code>:new</code>, adding begin &amp; end blocks, but none of them seem to work.</p>