Oracle updating through view

Rated 3.99/5 based on 940 customer reviews

If you are using a release of My SQL 5.1, see this document for licensing information, including licensing information relating to third-party software that may be included in this Commercial release.

For information changing conditions and their impact on views, see "Managing Object Dependencies". Base tables might in turn be actual tables or might be views themselves.All operations performed on a view actually affect the base table of the view.When a view is created, Oracle Database expands any wildcard (*) in a top-level view query into a column list.The resulting query is stored in the data dictionary; any subqueries are left intact.

Leave a Reply