Name
SET CONSTRAINT
Synopsis
SET {CONSTRAINT | CONSTRAINTS} {ALL |constraint_name
[,constraint_name
...]} {IMMEDIATE | DEFERRED}
Specifies at the transaction level whether specific constraints are checked after each DML statement or are deferred until the end of a transaction. This statement applies only to deferrable constraints. The success of deferrable constraints can be tested by issuing the statement SET CONSTRAINTS ALL IMMEDIATE before the COMMIT statement is issued.
Keywords
- ALL
Specifies that all deferrable constraints for the transaction are affected by this statement.
- constraint_name
Name of a deferrable constraint.
- IMMEDIATE
Specifies that the conditions enforced by the constraints be checked after each DML statement is completed.
- DEFERRED
Specifies that the conditions enforced by the constraints be checked after the entire transaction is complete and committed.
Get Oracle in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.