Updating tables through object views in oracle

Rated 4.48/5 based on 813 customer reviews

You would specify the where_clause when you want Oracle to execute the insert operation only if the specified condition is true.The condition can refer only to the MERGE data source.If the column list after the INSERT keyword is left out, the number of columns in the target table must match the number of values in the VALUES clause.

The decision to perform an insert or update is based on conditions specified by you.The MERGE statement uses the merge_insert_clause when the condition of the ON clause is false.As with any normal insert, if the insert clause is executed, all insert triggers defined on the target table are fired.USING Clause - The USING clause specifies the source of the data to be updated or inserted.The source for a MERGE statement can be a table, view, or the result of a subquery.

Leave a Reply