Updating views in oracle

Rated 3.90/5 based on 821 customer reviews

All Data Manipulation Language (DML) changes are done as part of a transaction.They are not permanent until they are confirmed using the statement.You will see a lot of Oracle examples on the internet using the tables from the SCOTT schema.You can find the original table definitions in the "$ORACLE_HOME/rdbms/admin/utlsampl.sql" script.

Views, which are a type of virtual tables allow users to do the following − Database views are created using the CREATE VIEW statement.Simple views are generally updateable via DML statements issued against the view.However, when a view becomes more complex it may lose its "updateable-ness," and the Oracle INSTEAD-OF trigger must be used.This offer the "illusion" that you are inserting into a non-insertable view (a super complex view which cannot accept DML).The Oracle INSTEAD-OF trigger has the ability to update normally non-updateable views.

Leave a Reply