The system table lists all schemas. Only users with the SELECT ANY DICTIONARY system privilege have access to the table.

Column Name Description
SCHEMA_NAME Name of the schema object
SCHEMA_OWNER Owner of the schema object
SCHEMA_OBJECT_ID ID of the schema object
SCHEMA_IS_VIRTUAL States whether this is a virtual schema
SCHEMA_COMMENT Comment on the object