Updating oracle views

Posted by / 08-Nov-2016 23:13

It’s not something that should be used often, but it’s always worth considering if you can understand the trade-offs.

Historically, one of the problems of using summary tables has been the initial loading and subsequent updating of the summary.

A view is simply any SELECT query that has been given a name and saved in the database.

The method, the time required to complete the commit may be slightly longer than usual.

This is because the refresh operation is performed as part of the commit process.

Although you don’t need to use them the first time that you create a view, including them will overwrite an older version of the view with your latest one, without giving you an error message.

• The syntax to remove a view from your schema is exactly what you would expect: A view name may be used in exactly the same way as a table name in any SELECT query.

updating oracle views-11updating oracle views-6updating oracle views-50

In SQL Server, if a view’s base tables are modified, then the view’s indexes are also kept up to date in the same atomic transaction. Oracle provides something similar called a materialized view.

One thought on “updating oracle views”

  1. Regardless of whether younger women looking for older men or older men dating younger women, Younger Women Looking For Older is certainly the most trusted site that would cater to your needs.