Re: Delete behaviour
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Tue, 4 Mar 2008 21:13:35 +0100
Message-ID: <47cdad74$0$14348$e4fe514c@news.xs4all.nl>
Date: Tue, 4 Mar 2008 21:13:35 +0100
Message-ID: <47cdad74$0$14348$e4fe514c@news.xs4all.nl>
"Serge Rielau" <srielau_at_ca.ibm.com> schreef in bericht
news:635bajF25s16vU1_at_mid.individual.net...
> Maxim Demenko wrote:
>> Notes on Updatable Views
>> ...
>> For a DELETE statement, if the join results in more than one key-
>> preserved table, then Oracle Database deletes from the first table
>> named in the FROM clause, whether or not the view was created WITH
>> CHECK OPTION.
> Anything I could write now would start a flame, so I won't.
>
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab
Agreed. It's documented.
Shakespeare Received on Tue Mar 04 2008 - 14:13:35 CST