查询数据库中的视图、存储过程、函数

select object_name,created,status
from user_objects
where object_type in ('PROCEDURE','FUNCTION','VIEW')