Skip to Main Content

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!

Default action that ORACLE would do if NOT MATCHED on MERGE operations

user11432758Mar 6 2015 — edited Mar 6 2015

Hi, I would like to ask, for a MERGE statement, what is the default action that oracle would do if NOT MATCHED encountered ?  For instance, I only specified MATCHED action and without NOT MATCHED action.

MERGE INTO POTENTIAL_PORT_SIG_TYPE b

USING

(

..................................

..................................

..................................

)ON (xxx =xxx)

WHEN MATCHED THEN

UPDATE STATEMENT;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 3 2015
Added on Mar 6 2015
17 comments
1,660 views