Oracle PL-SQL Question:
What is a database trigger? Name some usages of database trigger?
Answer:
Database trigger is stored PL/SQL program unit associated with a specific database table. Usages are Audit data modifications, Log events transparently, Enforce complex business rules Derive column values automatically, Implement complex security authorizations. Maintain replicate tables.
| Previous Question | Next Question |
| Explain the usage of WHERE CURRENT OF clause in cursors? | How many types of database triggers can be specified on a table? What are they? |