Hi...
I know trigger concept but I want to know SQL trigger and Oracle trigger are same ? Please explain with example anyone ?
Thanks....
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Feb 21, 2012, 10:36 PM
Trigger in both SQL and oracle is same but there is differnace in way of execution and type.
Oracle triggers
1)Row Triggers and Statement Triggers
2)BEFORE and AFTER Triggers
3)INSTEAD OF Triggers
4)Triggers on System Events and User Events
sql Triggers.
(i) After Triggers (For Triggers)
(ii) Instead Of Triggers
hope this help.