If we are creating trigger of delete type or update type than when the trigger will execute after delete or after update?

I dont knowplz give the ans. through my email

narendranaval
Profile Answers by narendranaval Questions by narendranaval
Oct 14th, 2005
4
1954

Showing Answers 1 - 4 of 4 Answers

REDDY

Nov 18th, 2005

Your question is not clear, when creating triggers we give the trigger timing (i.e) BEFORE or AFTER and the trigger will file accordingly
create or replace trigger <trigger name> timing <BEFORE\AFTER> event <INSERT\UPDATE\DELETE> ON table name ......trigger body..............

Priestly George Varghese

Oct 10th, 2007

If you are creating trigger using before keyword, then the trigger will fire before the particular query.
If you are creating trigger using after keyword, then the trigger will fire after the particular query.