Home » SQL & PL/SQL » SQL & PL/SQL » Re: Find record, that causes DUP_VAL_ON_INDEX
Re: Find record, that causes DUP_VAL_ON_INDEX [message #39447] Wed, 17 July 2002 12:59
Mike Muller
Messages: 4
Registered: July 2002
Junior Member
Obviously I should have started different...

I do have a table, that contains records, which I need to check because of doublets. Doublets are defined by the keys, which have been in the unique-key (this key does ofcoruse not exists on the "real" table, otherwise I wouldn't have the problem :)), in the other statement. So, if I find out, that 4 records are the same, then I need to delete 3 of them and just keep one.

Jes... I don't know, if u understand, what I mean and what I need 2do... :(

greetz
Previous Topic: How do I completely remove a tablespace?
Next Topic: Insert is lateness
Goto Forum:
  


Current Time: Thu Mar 28 11:22:25 CDT 2024