delete dup rows in oracle
 

hi...dudes...
can anyone post the simplest ans for deleting duplicate rows in oracle....

Re: delete dup rows in oracle
 

Check Delete duplicate rows from Oracle

Re: delete dup rows in oracle
 

try this one n let me know.. it will delete duplicate row from the table..


delete from employee t1 where exists(
select * from employee t2 where t2.name=t1.name and
t2.sa=t1.sa and t2.rowid>t1.rowid);

Re: delete dup rows in oracle
 

Ya this is working dude