Languages SQL Transactions  

Delete duplicates in a table (using a FOR UPDATE cursor and PL/SQL control)
download download  
important code information
author:
 Andy Archer
minimum requirements:
Delete duplicates in a table (using a FOR UPDATE cursor and PL/SQL control) description

This PL/SQL block deletes duplicate rows in a table, using a FOR UPDATE cursor and program control. Clear, concise comments are interspersed in the code. A test execution is included.


File List:
@PSC_ReadMe_997_5.txt1Kb
delete_duplicates_3.sql14Kb
Similar code
Delete duplicates in a table (cleanly and easily, using ROWID) (Popularity: ) : This simple SQL statement deletes duplicate rows in each set, using the pseudocolumn ROWID (row address), preserving the first inserted ...
User reviews

Write a review:
1 2 3 4 5 6 7 8 9 10
1=poor 10=excellent
Write review*
Your name*
Email*
  (Comments are moderated, and will not appear on this site until the editor has approved them)
 
Rate me
supported os
stats
downloads 35
version
size in Kb 4
popularity   364/5827733
user rating 3/10
ad


New Code
Popular Code