查詢資料庫中的視圖、存儲過程、函數

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