select object_name, object_type, created, last_ddl_time, status
from user_objects
where object_type in (‘PROCEDURE’,’FUNCTION’, ‘VIEW’)
order by last_ddl_time
/
select object_name, object_type, created, last_ddl_time, status
from
ALL_OBJECTS
where object_type in (‘VIEW’)
order by last_ddl_time
