Languages SQL Transactions  

Delete duplicates in a table (using a FOR UPDATE cursor and PL/SQL control)

download download home home  
important code information
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:

Similar code
Insert the ampersand (&) via SQL*Plus (Popularity: ) : This short write-up examines the role of the ampersand (&) in SQL*Plus, and shows how you can easily turn it into just another text character when you need to insert it into a table.
Update a table with itself, with one SQL statement (Popularity: ) : Sometimes you may need to update a table with its own data, typically when rows contain a link to values stored in other rows. The example SQL and narrative illustrate how to do this via an Update statement with a ...
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 row of each duplicate set.
User reviews

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

New Code
Popular Code