How to delete duplicate records in an Oracle database

I read something about the Oracle database because of some database problems.

For records in a table in an Oracle database, how can we delete repeated values. I will keep a record of my practices for future reference. The data I use is oracle.

Suppose there is a table

Create table test (name varchar2 (255), pass varchar2 (255 ));

What should I do if the database has multiple rows of duplicate records. I checked the information. Some people say that there are many methods to use a temporary table. For an oracle database, it has a rowid, which will never be repeated. We can use this to process repeated records.

Delete from test t where t. rowid not in (
Select c. r from (
Select distinct z. name, min (z. rowid) r from test z group by z. name
) C
)

In this way, the rowid is large and the record duplicate value is deleted. Of course, this can also be used to delete duplicate records in a single column in a database table.