GETTING ERROR

Given a table create a trigger that such that any DML operation performed will lead to storing of username,sysdate and DML action performed, to be stored in a table called locked with attributes(user_name,user_sysdate,usr_action) and also old values should be stored in a separate table

LINK FOR THE SCRIPT:-

https://livesql.oracle.com/apex/f?p=590:1:3221189824495:::RP::

ORACLE 11G SQL IS USED.

37 CREATE OR REPLACE TRIGGER dml_trigger AFTER INSERT OR UPDATE OR DELETE ON emp_1 FOR EACH ROW DECLARE v_username varchar2(30); v_sysdate date; v_action varchar2(30); BEGIN SELECT user_name, user_sysdate, usr_action, CASE WHEN INSERTING THEN 'INSERT' WHEN UPDATING THEN 'UPDATE' WHEN DELETING THEN 'DELETE' END INTO v_username, v_sysdate, v_action FROM dual; INSERT INTO Locked (user_name, user_sysdate, usr_action) VALUES (v_username, v_sysdate, v_action); IF INSERTING THEN ELSIF UPDATING THEN INSERT INT0 old_values (emp_num,emp_lname, emp_fname, emp_initial, emp_hiredate, emp_jobcode) VALUES (:old.emp_num, :old.emp_lname, :old. emp_fname, :old. emp_initial, :old.emp_hiredate, :old. emp_jobcode); END IF; END; Errors: TRIGGER DML_TRIGGER Line/Col: 6/5 PL/SQL: SQL Statement ignored Line/Col: 8/24 PL/SQL: ORA-00920: invalid relational operator