using trigger to update particular column with current_timestamp it says trigger created but do not update
<pre><code>create or replace trigger trg1
before
insert on patient
referencing old as old new as new
 for each row
 begin
 if inserting then
     update patient set p_join_date = current_timestamp where :old.patient_id= null;
 end if;
end;
</code></pre>