What are the types of triggers ?
Answer Posted / nitin
There is
1)DML trigger: with before/after,for each row/for statement,and for 3 types of DML operation.
2)Instead of trigger.
3)Database level trigger: Triggers on DDL statement.
4)System level trigger.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
How many sectors are in a partition?
How much does sql cost?
What is trigger and how to use it in sql?
What are the different tcl commands in sql?
Can a commit statement be executed as part of a trigger?
What is meant by temporal data?
how to write date and time literals? : Sql dba
Why cross join is used?
What is a rank in sql?
Is id a reserved word in sql?
How many clustered indexes can you have?
Explain correlated query work?
What is oracle and pl sql?
What is group function in sql?