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
How do I manually uninstall oracle client?
Which is faster join or subquery in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Explain oracle’s server parameter file.
Explain what are clusters?
What is a cursor variable?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Explain the use of log option in exp command.
What is a view and how is it different from a table?
How do I learn what codesets are available in oracle?
what is the scenario where you take the database to NoArchivelog mode?
What is data type in oracle?
How to join two tables in a single query using oracle?
How many types of auditing in Oracle?
