Create Internal Sequence to Uniquely Identify Duplicates (Oracle Database)

Step 1: Create Test Table: 

 

Result:

 

Step 2: Run PL/SQLl anonymous block to deal with the duplicates:

 

Result: