Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: Alexander.Kuznetsov@marshmc.com (Alexander Kuznetsov) Newsgroups: comp.databases.theory,comp.databases.ibm-db2,comp.databases.ms-sqlserver,comp.databases.oracle.misc Subject: Re: View updating in practice? Date: 11 Nov 2002 08:47:12 -0800 Organization: http://groups.google.com/ Lines: 22 Message-ID: References: NNTP-Posting-Host: 4.20.74.62 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1037033232 4239 127.0.0.1 (11 Nov 2002 16:47:12 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 11 Nov 2002 16:47:12 GMT Xref: newsfeed1.easynews.com comp.databases.theory:23552 comp.databases.ibm-db2:69309 comp.databases.ms-sqlserver:80995 comp.databases.oracle.misc:89208 X-Received-Date: Mon, 11 Nov 2002 09:46:57 MST (news.easynews.com) > > If I write a next version of that paper (depending on input I get > here ;) it will contain a list of views and updates that satisfy > this requirement. > do it. However controversial, that's a very interesting reading. It's nice to doubt the basics once in a while, sometimes even the basics get out-of-date. Another helpful updateable view: CREATE VIEW STINKY_STUFF AS SELECT * FROM REFRIGERATOR WHERE SELL_BY < CURRENT DATE; DELETE FROM STINKY_STUFF; there is no WHERE cluase and that's OK P.S. there are 2 more articles on updateable views on DB2 Developers Domain search on UNION ALL views