Updating views in oracle

Updating views in oracle

SELECT table_name, column_name, updatable 2 FROM user_updatable_columns 3 WHERE table_name LIKE 'UPDATEVIEW%'; TABLE_NAME COLUMN_NAME UPD------------------------- ------------------------- ---UPDATEVIEWNO ADDFIELD NOUPDATEVIEWYES FIELD1 YESUPDATEVIEWYES FIELD2 YESWITH READ ONLYWhat if you don't want anyone to update obase tables using your View?You can explicitly prevent users from modifying the base table through your View by creating it with the WITH READ ONLY clause.materialized views without query rewrite are supported in Standard editions.this means rewriting your queries to take advantage of the mat view but it also provides extra performance at reduced cost.When you're executing DML operations on a View, Oracle actually executes those DML operations appropriately on the base tables.And there are some cases where it is impossible for Oracle to do that.Well you can simply try and see, but there is another way.

How would Oracle know how to divide the new value we assigned?

Same goes if you have a collection expression or a subquery in a SELECT list.

USER_UPDATABALE_COLUMNSNot sure if your View can be updated or not?

This argument would hold for any situation where the View had a pseudocolumn or expression column, like this example, or perhaps one created through the use of DECODE. The Oracle SQL Reference details other situations where your View couldn't be updated.

For example, and along the same lines of reasoning, if the View contains a SET, DISTINCT, GROUP BY, GROUP, ORDER BY, CONNECT BY, START WITH, then Oracle can't perform any update or insert operations on the View.

updating views in oracle-77updating views in oracle-58updating views in oracle-84

Once committed, the only way you can revert a change is to issue a new DML statement to alter the data.

Join our conversation (52 Comments).
Click Here To Leave Your Comment Updating views in oracle.


  1. 1

    These people will have dates on a regular basis, and they may or may not be having sexual relations.

  2. 1

    The first riders to be caught were four amateurs, three Spanish (Luis Santamarina, Canet and Usamentiaga) and one Briton (Ken Hill), who were thrown out of the Milk Race when they tested positive for amphetamines after Professor Arnold Beckett first applied sensitive gas chromatographic techniques to monitor drug abuse. Raymond Poulidor was the first rider to be tested in the Tour at the end of a stage to Bordeaux.

  3. 1

    Sex Cam or Cyber Sex Cybersex, additionally called PC sex, Internet sex, netsex and, conversationally, cybering, is a virtual sex experience in which two or more individuals associated remotely by means of PC system send each other sexually express messages depicting a sexual ordeal.

  4. 1

    adam artık çok sabırsız olduğu için direk konuya giriyor ve seni çok arzuluyorum,istiyorum artı...

  5. 1

    Per il Sud Italia le date delle semine possono essere anticipate di 15-20 giorni (ma anche di 1 mese) a seconda della località in cui vi trovate (per avere un riferimento più oggettivo, potete dare uno sguardo alle temperature minime di semina), mentre per le zone di collina o di montagna (Alpi o Appennino) potrebbero essere ritardate di 1 o 2 mesi (a seconda dell'altitudine e dell'esposizione).

  6. 1

    They are then sent the world’s first DNA test designed for the dating industry, by their partners Instant Chemistry, a Toronto-based biotech company and the leader in Human genetic compatibility.

Leave a Reply

Your email address will not be published. Required fields are marked *