Re: Delete behaviour

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Tue, 04 Mar 2008 11:22:40 -0500
Message-ID: <635bajF25s16vU1@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

Received on Tue Mar 04 2008 - 10:22:40 CST

This message: [ Message body ]
Next message: sybrandb: "Re: Display of mutated vowels?"
Previous message: gazzag: "Re: Insufficient privs connecting as sysdba on local machine"
In reply to: Maxim Demenko: "Re: Delete behaviour"
Next in thread: Shakespeare: "Re: Delete behaviour"
Reply: Shakespeare: "Re: Delete behaviour"
Reply: DA Morgan: "Re: Delete behaviour"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message