SELECT * FROM USER_TABLES; -- Tables from connected schema
SELECT * FROM ALL_TABLES; -- Tables available to connected schema
SELECT * FROM ALL_TABLES WHERE OWNER = 'SCHEMA_NAME';
SELECT * FROM ALL_TABLES WHERE TABLES_NAME = 'TABLE_NAME';
SELECT * FROM DBA_TABLES; -- All Tables