ORA_SYSEVENT function returns the system event that was responsible for firing the trigger as a VARCHAR2 datatype.
SQL> SQL> SQL> BEGIN 2 dbms_output.put_line(ora_sysevent||' fired the trigger.'); 3 END; 4 / fired the trigger. PL/SQL procedure successfully completed. SQL> SQL>