The goal here is to determine which are the duplicated records and why. It happened to me that accounting ran twice the same process and there were duplicated records which were correct. Some of them were twice and another four times which were those right duplicated. So, Mayank, could you be more specific about your situation?
2009/5/29 ErikYkema <erik.yk...@gmail.com> > > I think one one can do something with 'delete ... where ... and rownum > = 1', possibly simplest in some PLSQL block with two cursors. > Regards, Erik > > On 29 mei, 14:41, Mayank <mayank.del...@gmail.com> wrote: > > Dear All, > > > > How Can we Delete Duplicate Records without using Rowid.? > > > > Best Regards > > Mayank > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
