after insert trigger : After Event Trigger « Trigger « Oracle PL/SQL Tutorial






SQL>
SQL> CREATE TABLE to_table
  2  (col1 NUMBER);

Table created.

SQL>
SQL>
SQL>
SQL> CREATE OR REPLACE TRIGGER after_insert_statement
  2  AFTER INSERT ON to_table
  3  BEGIN
  4    DBMS_OUTPUT.PUT_LINE('After Insert Statement');
  5  END;
  6  /

Trigger created.

SQL>
SQL> drop table to_table;

Table dropped.








28.7.After Event Trigger
28.7.1.After delete trigger
28.7.2.After update trigger
28.7.3.Using an AFTER EVENT Trigger
28.7.4.Creating a Trigger: AFTER INSERT OR DELETE OR UPDATE ON employee
28.7.5.Trigger for certain columns
28.7.6.AFTER INSERT OR UPDATE ON tableName
28.7.7.after insert trigger