The Oracle analytic function
ROW_NUMBER() can be used
identify duplicate data as shown in the query below. It
is easy to analyze and/or delete duplicate if a unique
record identifier exists in the table. In the absence of
a unique record identifier, ROWID can be used (refer -
Oracle registered trademark of Oracle Corporation.