Updating views in oracle

03-Jan-2017 02:39

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

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.

Error Banner.fade_out.modal_overlay.modal_overlay .modal_wrapper.modal_overlay [email protected](max-width:630px)@media(max-width:630px).modal_overlay .modal_fixed_close.modal_overlay .modal_fixed_close:before.modal_overlay .modal_fixed_close:before.modal_overlay .modal_fixed_close:before.modal_overlay .modal_fixed_close:hover:before.

Selector .selector_input_interaction .selector_input. Selector .selector_input_interaction .selector_spinner.

updating views in oracle-78updating views in oracle-71

That signals to Oracle that your View is meant for querying only.

The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

Join Views Thus far I've been talking only about cases where the View is based on a single base table.

What about when the View joins one or more base tables? Updating join views is a whole different ball of wax.

That signals to Oracle that your View is meant for querying only.

The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

Join Views Thus far I've been talking only about cases where the View is based on a single base table.

What about when the View joins one or more base tables? Updating join views is a whole different ball of wax.

The name "instead of" comes from the trigger syntax where you can specify "instead of" for a trigger: You can also see "instead of update" and "instead of delete" inside instead-of trigger syntax.