Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / vamsi krishna
triggers are the named pl/sql blocks which are executed
automatically at the specified events.the event at which
triggers are executed is called as the triggering
event.there are 3 types of triggers
(i) dml triggers:
these triggers are executed either before or after any dml
events(i.e insert or update or delete)
(ii) ddl triggers:
these triggers are executed either before or after any ddl
events(i.e create or alter or rename or truncate or drop)
(iii) database triggers
these trigger are executed either before or after any
database events(i.e logon or logoff or startup or shutdown)
database triggers can be created only by user having dba
privileges.
using triggers we can perform the following operations
(i) auto managing of data
(ii) auditing of data
(iii) auditing of events
(iv)defining of validations
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What happens if you set the sga too low in oracle?
What are the ways tablespaces can be managed and how do they differ?
various types of hints and their usage
How to use null as conditions in oracle?
What is recovery manager in Oracle?
why dont we assign not null constraint as table level constraint.
types of indexes and the rationale behind choosing a particular index for a situation.
What is the difference between hot backup and cold backup in oracle?
Explain what are clusters?
How oracle handles dead locks?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
Is postgres faster than oracle?
What is java oracle used for?
what is a Nested Loop join?
Where do we use decode and case statements?
