Updating oracle views

When creating an Oracle materialized view, you have the option of specifying whether the refresh occurs manually (ON DEMAND) or automatically (ON COMMIT, DBMS_JOB).

The Microsoft Biz Talk Adapter for Oracle Database surfaces a set of standard operations on each Oracle database table and view.

In this article, we continue our discussion of Oracle materialized views and discuss how to set up and configure your Oracle database to use this powerful new feature.

We begin with a look at the initialization parameters and continue with details of the effective management and use of Oracle materialized views.

Without the use of views, the normalization of databases above second normal form would become much more difficult.

Views can make it easier to create lossless join decomposition.

An updatable view lets you insert, update, and delete rows in the view and propagate the changes to the target master table.In addition to operating on base tables, one View can be based on another, a view can also JOIN a view with a table (GROUP BY or UNION).Using views encourages the use of Shared SQL with the benefit of reduced memory usage.A View can be used to simplify SQL statements for the user or to isolate an application from any future change to the base table definition.A View can also be used to improve security by restricting access to a predetermined set of rows or columns.Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from Tech Target experts.

You must have an account to comment. Please register or login here!