Updating two tables in oracle

posted by | Leave a comment

If both are specified, then the order of the clauses is not important.

merge_insert_clause To specify the values used for insert operations the merge_insert_clause is used.

An example of a constant filter predicate would be: A predicate such as the one shown is recognized by Oracle as a special case, and Oracle makes an unconditional insert of all source rows into the table.

Suppose I have table A and B and having four columns each table A(col1,col2,col3,col4) B(col1,col2,col3,col4) then how should i do something like this update A set(col2,col4)=(select B.col2, B.col4 from B where B.col1=A.col1 and A.col3=A.col3) Please help..........

MERGE is what is known as a deterministic statement.

That is, you can only update the same row of the target table once in the same MERGE statement.

Oracle performs the specified update if the condition of the ON clause is true.

As with any normal update, when the update clause is executed, all update triggers defined on the target table are fired.

Leave a Reply

  1. devotions for teen dating 14-Aug-2015 05:19

    The boy was thrown from a bridge into the bushes between Marken and Mokopane, about 40 kilometres from where he was last seen.

  2. what is the dating age law in colorado 24-Jul-2015 02:11

    So please have a complete look at the report generated by and don't forget to share it with your friends. COMDNSSEC: unsigned For complete domaindetails goto: Thisinformation is provided for the sole purpose ofassisting youin obtaining information about domain nameregistration records.

  3. Reel free sex chat 02-Aug-2016 16:13

    Here are 10 fantastic spots to hit the road when the wanderlust strikes: Distance from Nashville: 93 miles southeast; 1.5-hour drive Why it made our list: Best known as the home of The University of the South, this sleepy little college town offers all the amenities you’d expect or need for a relaxing weekend getaway.

Free chat raw sex