top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

what is deferred Integrity constraints in oracle?

+1 vote
220 views
what is deferred Integrity constraints in oracle?
posted Apr 27, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

Deferred Integrity Constraints:

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

A constraint is deferred if the system checks that it is satisfied only on commit. If a deferred constraint is violated, then commit causes the transaction to undo.

If a constraint is immediate (not deferred), then it is checked at the end of each statement. If it is violated, the statement is rolled back immediately.

If a constraint causes an action (for example, delete cascade), that action is always taken as part of the statement that caused it, whether the constraint is deferred or immediate.

answer Apr 27, 2015 by Shivaranjini
...