I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.
我最好寻找一个SQL查询来实现这一点，但是其他选项也可能有用。
3 个解决方案
#1
26
SELECT LAST_DDL_TIME, TIMESTAMP
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE'
AND OBJECT_NAME = 'MY_PROC';
LAST_DDL_TIME is the last time it was compiled. TIMESTAMP is the last time it was changed.
LAST_DDL_TIME是最近一次编译它。时间戳是最后一次更改。
Procedures may need to be recompiled even if they have not changed when a dependency changes.
程序可能需要重新编译，即使它们在依赖项更改时没有更改。
#2
0
SELECT name, create_date, modify_date
FROM sys.procedures order by modify_date desc
#3
0
Following query will do in Oracle
下面的查询将在Oracle中执行
SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = 'OBJ_NAME' ;
#1
26
SELECT LAST_DDL_TIME, TIMESTAMP
FROM USER_OBJECTS
WHERE OBJECT_TYPE = 'PROCEDURE'
AND OBJECT_NAME = 'MY_PROC';
LAST_DDL_TIME is the last time it was compiled. TIMESTAMP is the last time it was changed.
LAST_DDL_TIME是最近一次编译它。时间戳是最后一次更改。
Procedures may need to be recompiled even if they have not changed when a dependency changes.
程序可能需要重新编译，即使它们在依赖项更改时没有更改。
#2
0
SELECT name, create_date, modify_date
FROM sys.procedures order by modify_date desc
#3
0
Following query will do in Oracle
下面的查询将在Oracle中执行
SELECT * FROM ALL_OBJECTS WHERE OBJECT_NAME = 'OBJ_NAME' ;