Monthly Archives: June 2016

INSERT into a View with a GROUP BY Clause

Oren Nakdimon 1 Reply

When I wrote the previous post, about updatable views, I noticed an interesting issue. The documentation says: If a view is defined by a query that contains SET or DISTINCT operators, a GROUP BY clause, or a group function, then rows cannot be inserted into, updated in, or deleted from the base tables using the […]

Continue reading

Misconceptions about (Regular) Views Revealed when Presenting Editioning Views

Oren Nakdimon 1 Reply

Sometimes when you present an advanced feature, questions from the audience reveal misconceptions about basic features. It happens to me almost every time I talk about Edition-Based Redefinition. I present Editioning Views, and then I get questions that reveal misunderstandings about views in general. One such misunderstanding is regarding what is kept in the view […]

Continue reading