This command will delete duplicate data from any table:
delete from Table-Name a
where rowid <> ( select max(rowid)
from Table-Name b
where ltrim(rtrim(a.column1)) = ltrim(rtrim(b.column1)));
Tags:
Oracle SQL
This command will delete duplicate data from any table:
delete from Table-Name a
where rowid <> ( select max(rowid)
from Table-Name b
where ltrim(rtrim(a.column1)) = ltrim(rtrim(b.column1)));