1SELECT * FROM USER_TABLES; -- Tables from connected schema
2SELECT * FROM ALL_TABLES; -- Tables available to connected schema
3 SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
4 SELECT * FROM ALL_TABLES WHERE TABLE_NAME = 'TABLE_NAME';
5SELECT * FROM DBA_TABLES; -- All database Tables