Hi,

Here is the Pseudocode, which u can try
----------------

Procedure Populate_Target_table

Cursor c1 is selet * from Target_Table
MINUS
select * from Source Table

for x in c1 loop

Insert into Target_Table
By taking data from cursor;

Exception
Dup_val_on index

Update Target_table


You need to have a primary key for this to work