Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!HSNX.atgi.net!sienna.impulse.net!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Instead Of Triggers Date: Tue, 26 Apr 2005 08:46:58 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1114530178.28455@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <426e5935$0$1821$6c56d894@reader0.news.be.easynet.net> In-Reply-To: <426e5935$0$1821$6c56d894@reader0.news.be.easynet.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 24 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:241270 Frederic wrote: > Hi all, > > I have a view, which is a union of several tables, all these tables are > of a common object type. I would like to delete row from this view, I > thought about an Instead Of Trigger, but I 've read somewhere sometimes > that it is not a good idea to use this. Is it true ? No. Where did you read that? > Another question, I'm in 10g, ans I think that theses triggers used to > be only in Enterprise Edition, is it always true ? > > Thanks > > Frédéric No. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)