Answers

Question and Answer:

  Home  Oracle Programmatic Constructs

⟩ Explain What are the differences between Database Trigger and Integrity constraints?

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.

 192 views

More Questions for you: