Jonathan Lalou's blog

Case: you need the list of all tables in an Oracle DB.

Solution: run this query:

select * from user_objects where object_type = 'TABLE';

You can use a similar way to filter on table names, or get other types object such us triggers, procedures and indexes.