Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: referential integrity
mike7411_at_gmail.com wrote:
> At what point does Oracle enforce referential integrity?
>
> For instace, if you have autocommit off and execute a series of
> statements, will it check referential integrity after each statement or
> after the "commit"?
>
> Thank you.
Vladimir's explanation is correct. If you want a demo you can run on deferrable constraints check out CONSTRAINTS in Morgan's Library at www.psoug.org.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Aug 09 2006 - 13:33:44 CDT