|Oracle9i SQL Reference
Release 2 (9.2)
Part Number A96540-02
CONSTRAINTS statement to specify, for a particular transaction, whether a deferrable constraint is checked following each DML statement or when the transaction is committed.
To specify when a deferrable constraint is checked, you must have
SELECT privilege on the table to which the constraint is applied unless the table is in your schema.
Specify the name of one or more integrity constraints.
ALL to set all deferrable constraints for this transaction.
IMMEDIATE to indicate that the conditions specified by the deferrable constraint are checked immediately after each DML statement.
DEFERRED to indicate that the conditions specified by the deferrable constraint are checked when the transaction is committed.
You can verify the success of deferrable constraints prior to committing them by issuing a
The following statement sets all deferrable constraints in this transaction to be checked immediately following each DML statement:
The following statement checks three deferred constraints when the transaction is committed. This example fails if the constraints were specified to be