plsql - Oracle SQL Query for listing all Schemas in a DB

Question

I wanted to delete some unused schemas on our oracle DB.

How can I query for all schema names ?

Answer 1

Using sqlplus

sqlplus / as sysdba

run:

SELECT * 
FROM dba_users

Should you only want the usernames do the following:

SELECT username 
FROM dba_users