ORACLE constraints can have attributes

• DEFERRABLE or NOT DEFERRABLE
• INITIALLY DEFERRED or INITIALLY IMMEDIATE

DEFERRED constraints takes the power on the end of transaction on the commit. On constraint violation the transaction will rollback.
If the constraint invokes some action (for example DELETE CASCADE), this action is taken as a part of the statement that invokes this action whether this constraint is deferred or not.