Delete duplicates in a table (cleanly and easily, using ROWID) description
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.
File List:
@PSC_ReadMe_884_5.txt
1Kb
delete_duplicates_2.sql
2Kb
Similar code
Delete duplicates in a table (using a FOR UPDATE cursor and PL/SQL control)
(Popularity: ) : 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. 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 ...
Code Library
) : 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.