Trigger Body

We have a trigger on database. In the trigger body we have created a body using dbms_output.put_line(********) ;
How to fire this ?

jkverma29
Profile Answers by jkverma29 Questions by jkverma29
Aug 19th, 2008
1
2946

Questions by jkverma29

Basics

Answer

Showing Answers 1 - 1 of 1 Answers

ushaudayam
Profile Answers by ushaudayam

Aug 22nd, 2008

Trigger is a pl/sql block that is automatically invoked on an event, when any DML command is used on corresponding table.
Triggers are classified into different categories based on when they are to be fired and where they are to be executed.

-Row level Triggers
   -Before Insert
   -Before Delete
   -Before Update
   -After Insert
   -After Delete
   -After Update
-Statement level Triggers
   -Before Insert
   -Before Delete
   -Before Update
   -After Insert
   -After Delete
   -After Update

Depending on the requirement we can fire the trigger when ever we want the pl/sql block to be executed