To eliminate duplicates without using the distinct command in PL/SQL, we can use the GROUP BY clause.

• Use the GROUP BY clause to group the data by the columns that you want to eliminate duplicates from...read more

we delete duplicate data by using rowid

We can delete duplicate rows using rowid