Is there more efficient way remove duplicate records?strsql := 'delete from ' || TableName || ' awhere rowid <(  select max(rowid) from ' || TableName || ' b  where a.val=b.val)';
Efficient way to remove duplicate records
sql;oracle