You cannot issue SET CONSTRAINT statement inside trigger. - Oracle Schema

Q.  You cannot issue a SET CONSTRAINT statement inside a trigger.
- Published on 29 Jul 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - When the database checks a constraint, it signals an error if the constraint is not satisfied.

    - You can defer checking the validity of constraints until the end of a transaction.

    - When you issue the SET CONSTRAINTS statement, the SET CONSTRAINTS mode lasts for the duration of the transaction, or until another SET CONSTRAINTS statement resets the mode.

Post your comment / Share knowledge


Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)