tag:blogger.com,1999:blog-7631414.post109785006967635080..comments2023-05-31T04:00:19.993+00:00Comments on Tony Andrews on Oracle and Databases: Enforcing complex constraints in OracleTony Andrewshttp://www.blogger.com/profile/16750945985361011515noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-7631414.post-46642938645606464042018-06-11T14:00:55.541+00:002018-06-11T14:00:55.541+00:00Another problem with MVs is that they don't su...Another problem with MVs is that they don't support distributed transactions.Unknownhttps://www.blogger.com/profile/01551140872112957579noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-1137968621232400232006-01-22T22:23:00.000+00:002006-01-22T22:23:00.000+00:00Just to point out that Standard Edition Oracle doe...Just to point out that Standard Edition Oracle doesn't allow ON COMMIT REFRESH. It is an Enterprise Edition feature.<BR/><BR/>http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:4541191739042SydOraclehttps://www.blogger.com/profile/08828771074492585943noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-1098975695905829922004-10-28T15:01:00.000+00:002004-10-28T15:01:00.000+00:00OK, I do see the distinction you are making. And a...OK, I do see the distinction you are making. And asking the DBMS vendor (Oracle) to enhance its declarative constraints is really where I started with this question on Ask Tom:<br /><br />http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:21389386132607<br /><br />But since right now there is no built-in, declarative, solution, we have to do the best we can. And to me, a solution Tony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-1098532546720625372004-10-23T11:55:00.000+00:002004-10-23T11:55:00.000+00:00Thanks for your comments. But I must take issue wi...Thanks for your comments. But I must take issue with this one:<br /><br />> You claim that complex rules can be implemented declaratively. Yet your article only shows a neat trick which is not declarative.<br /><br />I would say that "create materialized view" is declarative, in the same way that a constraint is declarative: there is no procedural code involved, and the DBMS takes care of Tony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.comtag:blogger.com,1999:blog-7631414.post-1098532232318818942004-10-23T11:50:00.000+00:002004-10-23T11:50:00.000+00:00This comment has been removed by a blog administrator.Tony Andrewshttps://www.blogger.com/profile/16750945985361011515noreply@blogger.com