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/Alternative

User_F3HNYJul 23 2020 — edited Jul 23 2020

Hi All,

I have source and taget table.

I want to insert into source if there is an extra rows in target and delete from source if there is an extra rows in source.

How can I achieve this?as per my knowledge we can't use MERGE.

I am using oracle 12C.

Thank You.

Added on Jul 23 2020

8 comments

1,134 views