</pre><BR><BR>My method so far has been to select all clientIDs with multiple records (group by clientid having count(*) > 1) and using a cursor + dynamic SQL to insert all the records for a given ...

Developers often dismiss dynamic SQL used in PL/SQL programs for two reasons. One reason is that it's riskier because the SQL statements aren't parsed until runtime, so it's more difficult to catch ...