Compare two cursors and Insert or Update
Posted on 2006-10-31
I have cursor1 which has col1A,col2A,col3A,col4A and cursor2 with col1B,col2B,col3B,col4B
Now i have to compare each record from cursor1 with corresponding fields with cursor2 records and if found then update and if not found insert the new record into table xyz.
The cursor1 would bring the records from table abc whereas cursor2 would bring the records from xyz table.