Queries below list tables in (A) your schema and (B) a specific schema you have access to.
A. List of tables in YOUR schema
select object_name as table_name from user_objects where object_type = 'TABLE' order by object_name
B. List of tables in SPECIFIC schema
select object_name as table_name from all_objects t where object_type = 'TABLE' and owner = 'SCHEMANAME' order by object_name
- table_name - name of the table
- One row represents one table
- Scope of rows: all tables in the schema
- Ordered by table name
Result shows list of tables in INV schema of our test database:
You could also get this
Get this interactive HTML data dictionary in minutes with Dataedo.