how to drop/remove a single row ??

[kool_max]

Hello,

How would u go about deleting a signle row form a table?? As the data got duplicated on that table. Same data is there twice and i just need to remove one of them rows?? How would u go about doing that??? is there a drop row cmd or something like that?? Thanks

[OracleDisected]

Hi,

You have two options:
1) use ROWID
2) Delete both, insert one (if you don't have referential integrity enabled)

[PAVB]

You don't drop rows, you drop objects; rows can be deleted.

1- Save one of your rows in a temp table, you can create your temp table as select * from your-table where your-conditions and rownum < 2; commit;

2- Check you have your row safe

3- Delete both rows as OracleDisected said.

4- Insert your saved row from your temp table.

You may want to consider PK constraint or at least a Unique Index in that table.

[gandolf989]

You might also rename the table and recreate the table with a group by to fitler out the duplicates. For non-key rows you need a way to specify which one you want, i.e. max, min, etc.

[LKBrwn_DBA]

Or if you are very brave:

DELETE FROM The_Table T
 WHERE ROWID > (
  SELECT MIN(ROWID) FROM The_Table X
   WHERE X.Key = T.Key);