Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: referential integrity

Re: referential integrity

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 09 Aug 2006 11:33:44 -0700
Message-ID: <1155148425.710198@bubbleator.drizzle.com>


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.org
Received on Wed Aug 09 2006 - 13:33:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US