Javatpoint Logo
Javatpoint Logo


This statement specifies that Oracle will fire this trigger AFTER the INSERT/UPDATE or DELETE operation is executed.



OR REPLACE: It is an optional parameter. It is used to re-create the trigger if it already exists. It facilitates you to change the trigger definition without using a DROP TRIGGER statement.

trigger_name: It specifies the name of the trigger that you want to create.

AFTER INSERT or UPDATE or DELETE: It specifies that the trigger will be fired after the INSERT or UPDATE or DELETE operation is executed.

table_name: It specifies the name of the table on which trigger operation is being performed.


  • AFTER trigger cannot be created on a view.
  • You cannot update the OLD values.
  • You can only update the NEW values.

Oracle AFTER Trigger Example

Consider, you have a "suppliers" table with the following parameters.

You can use the following CREATE TRIGGER query to create a AFTER INSERT or UPDATE or DELETE Trigger:

Here the trigger name is "SUPPLIERS_T2" and it is fired AFTER the insert or update or delete operation is executed on the table "suppliers".

Oracle After Trigger

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA