Queries below list all schemas in Oracle database, including Oracle maintained ones.

Queries were executed under the Oracle9i Database version.

Query

A. Generic query

select username as schema_name
from sys.all_users
order by username;

B. If you have privilege on dba_users

select username as schema_name
from sys.dba_users
order by username;

Columns

• schema_name - schema name

Rows

• One row represents one schema in a database
• Scope of rows: all schemas in a database, including default ones
• Ordered by schema name

Sample results

Here is a view of database schemas in Oracle SQL Developer: