Programmatic Constructs Question:
Explain What are the differences between Database Trigger and Integrity constraints?
Answer:
A declarative integrity constraint is a statement about the database that is always true. A constraint applies to existing data in the table and any statement that manipulates the table. A trigger does not apply to data loaded before the definition of the trigger, therefore, it does not guarantee all data in a table conforms to the rules established by an associated trigger. A trigger can be used to enforce transitional constraints where as a declarative integrity constraint cannot be used.
Previous Question | Next Question |
Explain What is an Oracle Data Block? | Explain What are the different types of PL/SQL program units that can be defined and stored in ORACLE database? |