In Temp_table do insert and in Target_table do Delete existing rows WHERE temp_table.column1=target_table.column1 and temp_table.column2 != target_table.column2
I have a random question just came up in my mind. For eg. -Suppose I want to do UPSERT 2M rows in oracle table. -Now due to some reasons the job is aborted after processing 1M rows. -Either I can reset the job and run again or look for another option as 50% work is done. -I will go for another optio...