oracle all tables in schema
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 TABLE_NAME = 'TABLE_NAME'; SELECT * FROM DBA_TABLES; -- All database Tables