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 is not equal to in oracle?
How to get the Installed Oracle Version Information ?
How do I manually uninstall oracle client?
What is columnar storage what is the advantage?
Explain index?
How to start an oracle instance?
Explain the features of oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Define oracle database
Is there a function to split a string in plsql?
How to define a specific record type?
What language does oracle use?
Which are the five query types available in oracle?
Explain table?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
