Find Last Update Date/Time for an Oracle PL/SQL Procedure-优快云博客

博客围绕在Oracle数据库中查找PL/SQL过程的更新时间展开，给出了查询当前用户模式下FIND_USER过程信息（含创建和更新日期）的SQL查询，还提及可查询有访问权限的任意模式下PL/SQL过程的类似信息，数据库管理员可查询任意模式下过程信息。

Problem
You need to find when a PL/SQL procedure in an Oracle Database was updated.

Solution
The following SQL query returns information about a FIND_USER procedure, defined in the current user’s schema. The information returned includes procedure name, date procedure was created and date procedure was updated.

SELECT o.object_name AS object_name,
       o.created AS date_created,
       o.last_ddl_time AS date_updated
  FROM user_objects o
 WHERE o.object_type = 'PROCEDURE'
       AND o.object_name ='FIND_USER';

The following SQL query retrieves similar information for any PL/SQL procedure in any Oracle Database schema you have granted access to.

SELECT o.object_name AS object_name,
       o.owner AS object_schema,
       o.created AS date_created,
       o.last_ddl_time AS date_updated
  FROM all_objects o
 WHERE o.object_type = 'PROCEDURE'
       AND o.object_name ='FIND_USER';

Database Administrator can query information about procedures, defined in any schema.

SELECT o.object_name AS object_name,
       o.owner AS object_schema,
       o.created AS date_created,
       o.last_ddl_time AS date_updated
  FROM dba_objects o
 WHERE o.object_type = 'PROCEDURE'
       AND o.object_name ='FIND_USER';

转载于:https://www.cnblogs.com/simonhaninmelbourne/archive/2013/01/23/2872434.html