Edited by Oscuro87, Maluniu, Lojjik Braughler, Maniac and 9 others Duplicate rows in Oracle can only be differentiated by using its 'rowid' (row address). Ad Steps 1 Delete the row by using its rowid. It's about the easiest way to delete the record. SQL > SELECT ROWID,name FROM names; ROWID NAME ------------------ ------------------------------ AABJnsAAGAAAdfOAAA Alan AABJnsAAGAAAdfOAAB Alan AABJnsAAGAAAdfOAAC Carrie AABJnsAAGAAAdfOAAD Tom 4 ROWS selected. SQL > DELETE FROM names WHERE ROWID='AABJnsAAGAAAdfOAAA'; 1 ROW deleted. SQL > COMMIT; COMMIT complete. SQL > SELECT ROWID,name FROM names;
Read full article from How to Delete Duplicate Records in Oracle (with Pictures)
No comments:
Post a Comment