Create a trigger for displaying a message “Record is inserting “before insertion of each row in the department table.

SQL> create or replace trigger addtri before insert on dept for each row
2 Begin
3 dbms_output.put_line('Record is inserting');
4 end;
5 /

Trigger created.

SQL> insert into dept values(50,'Finance','America');

1 row created.