SELECT object_type, object_name, last_ddl_time
FROM user_objects
WHERE object_type IN ('PROCEDURE', 'TABLE')
ORDER BY last_ddl_time DESC, object_type;
SELECT object_type, object_name, last_ddl_time
FROM user_objects
WHERE object_type IN ('PROCEDURE', 'TABLE')
ORDER BY last_ddl_time DESC, object_type;