Queries below list all schemas in Oracle database, including Oracle maintained ones.
Queries were executed under the Oracle9i Database version.
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;
- schema_name - schema name
- One row represents one schema in a database
- Scope of rows: all schemas in a database, including default ones
- Ordered by schema name
Here is a view of database schemas in Oracle SQL Developer: