title: Trigger with case in oracle
body: <p>I've got a problem with creating trigger in oracle, I have a table "Tickets" where I have fields "Price" and "Type". I'd like to make a trigger which adds price depending on the type of ticket (normal/reduced). </p>
  
  <p>I'm using <code>CASE</code> but it doesn't work at all. Here's my code:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER TYPE_BIR
  BEFORE INSERT ON Tickets
  FOR EACH ROW
  
  BEGIN
      CASE
        WHEN type = "normal" THEN :new.price := "15"
        WHEN type = "reduced" THEN :new.price := "12"
  END;
  </code></pre>