Oracle deferrable options

To explain, the constraint test is delayed until the execution of COMMIT. The following are specific explanations and examples. The constraint defined as deferrable can be specified:

1. initially immediate (Initialization is executed immediately) or

2. initially deferred (initialization delay execution ).

Explain the differences between the two. Initialization immediate execution/delayed execution specifies how constraints should be executed by default:

Initialize and execute now -- check constraints at the end of each statement

Initialization delayed execution-constraints are verified until the transaction is completed (or when the set constraint immediate statement is called ).