Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table contact ( action varchar2(20),org_name  varchar2(20) );
create table contact_log_history ( action varchar2(20),org_name  varchar2(20) );
CREATE  OR 
replace TRIGGER contact_af_update AFTER 
UPDATE 
ON contact FOR EACH ROW DECLARE 
BEGIN 
  IF (:new.action = 'After_Update_Contact') THEN 
    INSERT INTO contact_log_history 
                ( 
                            org_name, 
                            action 
                ) 
                VALUES 
                ( 
                            :new.org_name, 
                            :new.action 
                ); 
   
  END IF ; 
END;
/
select * from user_errors;
insert into contact(action,org_name) values('Update_Contact','An Oraganisation');
1 rows affected

update contact set action = 'After_Update_Contact';
1 rows affected

select * from contact;


ACTION
ORG_NAME


After_Update_Contact
An Oraganisation


select * from  contact_log_history;


ACTION
ORG_NAME


After_Update_Contact
An Oraganisation