Updating view

An object view is a view of a user-defined type, where each row contains objects, each object with a unique object identifier.You can also create object privilege on the superview. Typically, it does a good job with this, so the update view plan may look very similar to a plan for a simple update to the single affected base table. Then read this blog I wrote recently to see how it could be affected. But actually it didn't return records because the referenced table has changed by the update.

LOCATIONKEY FROM my Slb SB, my USERPROF U WHERE SB.

For nearly half of that time, Ask Tom has been there.

Here is a look back at those years, and here's to the next 40! --This is updatable CREATE OR REPLACE VIEW V_my View AS SELECT A.

To use the basic constructor method of an object type when creating an object view, one of the following must be true: to re-create the view if it already exists.

You can use this clause to change the definition of an existing view without dropping, re-creating, and regranting object privileges previously granted on it.