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
Can multiple columns be used in group by in oracle?
How to create a table index?
What is rich query?
How many types of auditing in Oracle?
How to sort output in descending order in oracle?
Explain what are synonyms used for?
How to rollback the current transaction in oracle?
What are the different types of database objects?
Explain constraining triggers.
Write a trigger example in oracle?
can u plz provide me oca sql dumps please i need them
How can we view last record added to a table?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to convert a date to char in oracle? Give one example.
What is backup in Oracle?
