John Topley's Knowledgebase

SQL Statement To List Tables Within Current Schema

This Oracle SQL statement will display the names of all the tables within the current user's schema.

SELECT table_name FROM user_tables;

To display the names of all the tables that the current user has access to, use:

SELECT table_name FROM all_tables;