Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Assertions Dilemma Revisted
>Jonathan Gennick wrote:
> An immediate constraint is one that is checked immediately after a
statement executes.
Do you mean after a SQL statement for example? or when you define a table?
>A deferred constraint is one that is not checked until you commit your
transaction.
Dont understand the term 'commit your transaction'.
>A deferred foreign-key constraint, for example, will allow you to insert
child >rows first and the parent row last, and everything will be ok as long
as you have it all straight when you commit.
Ok. This sounds like disabling a contraint and enabling it again when the tables have been created.
> I don't understand the second part of your question.
The book I am currently reading makes note of assertions with partial rollback and rollback.
-- N e w s N e t C u s t o m e r E - m a i l : sted.alana_at_hotmail.comReceived on Sun Apr 28 2002 - 10:12:03 CDT