Find Database Objects in Oracle

SELECT DISTINCT object_type
FROM   all_objects;

SELECT t.*
FROM   all_objects t
WHERE  t.object_type IN ('VIEW', 'TABLE', 'INDEX', 'MATERIALIZED VIEW', 'SYNONYM', 'FUNCTION', 'TRIGGER');