I run a pl/sql script that updates records in a table. In some cases a record that it tries to update to, already exists in the table which causes a unique constraint voilation exception.
What changes can I make to the script whereby whenever a unique constraint is violated, it simply does not update that specific record and move on to the next record and continue with the update as normal?
Would appreciate examples for clarification.
Thhanks.