--查看存储过程最新修改时间 --TRIGGER -- VIEW --SEQUENCE --TABLE --FUNCTION --PROCEDURE
SELECT OBJECT_NAME,CREATED,LAST_DDL_TIME FROM USER_OBJECTS WHERE OBJECT_TYPE =UPPER('PROCEDURE') ORDER BY LAST_DDL_TIME DESC;
SELECT OBJECT_NAME,CREATED,LAST_DDL_TIME FROM USER_OBJECTS WHERE OBJECT_TYPE =UPPER('PROCEDURE') ORDER BY CREATED DESC;
--查看状态为invalid的存储过程
SELECT OBJECT_NAME,CREATED,LAST_DDL_TIME ,STATUS FROM USER_OBJECTS WHERE OBJECT_TYPE =UPPER('PROCEDURE') and status!='VALID'
ORDER BY LAST_DDL_TIME DESC;
查询oracle数据库存储过程创建和修改日期脚本
最新推荐文章于 2023-11-20 17:49:29 发布