SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

merge: WHEN MATCHED THEN "do nothing"

391271Dec 12 2006 — edited Dec 22 2006

Hello !

using the merge command I would like only to insert, since the records are not changing once written.

Therefore in the case of a match: WHEN MATCHED I would like the query to do nothing...

Those simple things...

without the WHEN MATCHED THEN the query does not compile...

so, what should I put there?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2007

Added on Dec 12 2006

28 comments

48,461 views