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
Explain the use of grant option in imp command.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What happens if you set the sga too low in oracle?
What are the different types of partitions in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
How to define an oracle sub procedure?
How to use regular expression in pattern match conditions in oracle?
What is oracle host variable?
State and explain about oracle instance?
State and explain the different types of data models?
How does Oracle guarantee data integrity of data changes?
Compare and contrast between sql and sql server and explain its various functions?
How many data types are supported?
What is proxy method?
What is ASM (Automatic Storage Management) in Oracle?
