Answer: To delete duplicate rows we need to first define the criteria for considering two rows duplicate of each other.
Let say in a given table Test_table if column_1 and column_2 of two rows are same, then these rows are considered equal.
In Oracle we can use rowid of two rows to find that these rows are different.
Query to delete duplicate rows will be as follows:
a.column_1 = b.column_1
a.column_2 = b.column_2