Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / anitha
A trigger is a set of actions that are run automatically when a specified change operation is performed on a specified table. The change operation can be an SQL INSERT, UPDATE, or DELETE statement, or an insert, update, or delete high level language statement in an application program
types of triggers.
• Before delete trigger
• Before insert trigger
• Before update trigger
• After delete trigger
• After insert trigger
• After update trigger
• Read only trigger (external trigger only)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to find primary key of a table in db2?
What is a page in db2?
What is dbrm? What it contains?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is clone table?
What is difference between alias and synonym in db2?
How to run db2 command in windows?
List out the three types of page locks that can be held.
What is explain in db2?
What is temporal table in db2?
How do I delete a table in db2?
How to check last update on table in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Which component is used to execute the sql statements?
What do you mean by rollback?
