What are the types of triggers ?
Answer Posted / vijay
12 types of trigger
SATEMENT LEVEL TRIGGER
1.before insert
2.before update
3.before delete
4.after insert
5.after update
6.after delete
ROW LEVEL TRIGGER
7.before insert
8.before update
9.before delete
10.after insert
11.after update
12.after delete
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is left join in sql?
Why do we use joins in sql?
what is 'mysqldump'? : Sql dba
What is sql query limit?
How do I count duplicates in sql?
how can we submit a form without a submit button? : Sql dba
Which type of cursor is used to execute the dml statement?
1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins
Explain the difference between 'between' & 'and' operators in sql
Why we use sql profiler?
Difference between global and parameter variables?
What does the file extension accdb stand for?
Can we create view in stored procedure?
What is sequence in sql?
What are sql functions? Describe the different types of sql functions?