John Topley's Knowledgebase

SQL Statement To List Schemas

This Oracle SQL statement will display a list of schemas within the database.

SELECT username FROM all_users ORDER BY username;

To get Oracle SQL*Plus to display a page at a time, use:

set pause on

—And press Enter to page.