List schemas in Oracle database

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

Sample results

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

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
There are no comments. Click here to write the first comment.