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!

Delta load logic using oracle merge/delete sql statement

user12251389Jan 19 2021 — edited Oct 20 2021

I have table TEST_RUA where i am importing data daily. I am using Truncate and Insert logic for this table. Now i have another table TEST_RUA_MER same like table TEST_RUA where i want to apply Delta load logic. There is always unique combination of column values ID_LL, ID_UU, TKR in both table.

This post has been answered by Frank Kulash on Jan 19 2021

Jump to Answer

Added on Jan 19 2021

#delete, #insert, #oracle, #sql, #update

23 comments

2,463 views

4 mentions