Skip to content

Instantly share code, notes, and snippets.

@StuffbyYuki

StuffbyYuki/SQL:Oracle - list all schema names

Last active April 27, 2020 00:39
Show Gist options
  • Save StuffbyYuki/5b0c8eb4195533b83ab3ce9c4dcc1e94 to your computer and use it in GitHub Desktop.
Save StuffbyYuki/5b0c8eb4195533b83ab3ce9c4dcc1e94 to your computer and use it in GitHub Desktop.
Download ZIP
SQL:Oracle - list all schema names
Raw
SQL:Oracle - list all schema names
select username as schema_name
from sys.all_users
order by username;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment