title: Updating trigger (how)
body: <p>can someone help with updating a trigger? I know I am supposed to use the alter clause but after that I am stuck. I would like to alter this trigger:</p>
  
  <pre><code>CREATE OR REPLACE TRIGGER  "CR_SURGERY_AUDIT"  
  before insert or delete or update on CR_SURGERY
  for each row
  declare 
  V_user varchar2 (30);
  V_date varchar2 (30); 
  begin 
  select user, to_char(sysdate, 'dd/mon/yyyy hh24:mi:SS') INTO v_user, v_date
  from dual;
  IF inserting THEN
  insert into CR_SURGERY_AUDIT (new_name, old_name, user_name, entry_date, operation)
  VALUES (:NEW.CR_SURGERY, NULL, v_user, v_date, 'insert');
  ELSIF DELETING THEN
  insert into CR_SURGERY_AUDIT (new_name, old_name, user_name, entry_date, operation)
  VALUES (null, :OLD.CR_SURGERY, v_user, v_date, 'delete');
  ELSIF UPDATING THEN
  insert into CR_SURGERY_AUDIT (new_name, old_name, user_name, entry_date, operation)
  VALUES (:NEW.CR_SURGERY, :OLD.CR_SURGERY, v_user, v_date, 'Update');
  END IF;
  END;
  </code></pre>
  
  <p>I know it's simple but I cannot find a way to compose it. I want to add FK_SOCRD_ID so it updates to:</p>
  
  <pre><code>select user, to_char(sysdate, 'dd/mon/yyyy') INTO v_user, v_date from dual;
  IF inserting THEN
  insert into CR_SURGERY_AUDIT (new_name, old_name, user_name, entry_date,
  operation, FK_SOCRD_ID)  
  VALUES (:NEW.CR_SURGERY, NULL, v_user, v_date, 'insert');
  </code></pre>