Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of triggers ?
- 26 Answers
- 60953 Views
- Aspire, BirlaSoft, TCS, I also Faced
- E-Mail Answers
Answer Posted / arpit gautam
There are two types of triggers:
1.Row Triggers and Statement Triggers
A row trigger is fired each time the table is affected by
the triggering statement. For example, if an UPDATE
statement updates multiple rows of a table, a row trigger
is fired once for each row affected by the UPDATE
statement. If a triggering statement affects no rows, a row
trigger is not run.
A statement trigger is fired once on behalf of the
triggering statement, regardless of the number of rows in
the table that the triggering statement affects, even if no
rows are affected. For example, if a DELETE statement
deletes several rows from a table, a statement-level DELETE
trigger is fired only once.
2.BEFORE and AFTER Triggers
BEFORE triggers run the trigger action before the
triggering statement is run.
AFTER triggers run the trigger action after the triggering
statement is run.
Trigger Type Combinations
a. BEFORE statement trigger
b.BEFORE row trigger
c.AFTER statement trigger
d.AFTER row trigger
3.INSTEAD OF Triggers
INSTEAD OF triggers provide a transparent way of modifying
views that cannot be modified directly through DML
statements (INSERT, UPDATE, and DELETE). These triggers are
called INSTEAD OF triggers because, unlike other types of
triggers, Oracle fires the trigger instead of executing the
triggering statement.
4.Triggers on System Events and User Events
System events
Database startup and shutdown
Data Guard role transitions
Server error message events
User events
User logon and logoff
DDL statements (CREATE, ALTER, and DROP)
DML statements (INSERT, DELETE, and UPDATE)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is data control language?
What is trigger price?
Can we use view in stored procedure?
Explain two easy sql optimizations.
What is dense_rank?
Where the sql database files are stored?
Why do we use procedures in pl sql?
Why do you partition data?
How can you create an empty table from an existing table?
what is the difference between a having clause and a where clause? : Sql dba
Is it possible to create startup or shutdown trigger for on-schema?
What is the most important ddl statements in sql are?
Why sql query is slow?
What are the advantages of sql? Explain
How to get unique records from a table?
