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

Home -> Community -> Usenet -> comp.databases.theory -> Re: delete cascade

Re: delete cascade

From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 23 Apr 2007 01:04:25 GMT
Message-ID: <tCTWh.27145$PV3.282312@ursa-nb00s0.nbnet.nb.ca>


paul c wrote:

> Bob Badour wrote:
> ...
>

>> Would it suffice to declare the view using the RVA as above and then 
>> project away the RVA?

>
> I'm guessing that you mention rva's so that there can be no chance that
> a product would be permitted to only partially complete the operation,
> and leave some items dangling, whereas some products might allow a
> series of delete statements to be interrupted?

I mention it because it would fully disclose the data to be deleted, which is the invoice and the associated items. Received on Sun Apr 22 2007 - 20:04:25 CDT

Original text of this message

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