Oracle SQL Query for listing all Schemas in a DB

January 1, 2023 by Tarik

Using sqlplus

sqlplus / as sysdba

run:

SELECT * 
FROM dba_users

Should you only want the usernames do the following:

SELECT username 
FROM dba_users