ORACLE DBA查询 table function procedure 更新情况(限于DDL语句)

select *
  from dba_objects
 where owner = 'IDHR'
   and (created > to_date('2013-04-23 00:00:00', 'YYYY-MM-DD hh24:mi:ss') or
       to_date(timestamp, 'YYYY-MM-DD hh24:mi:ss') >
       to_date('2013-04-23 00:00:00', 'YYYY-MM-DD hh24:mi:ss'));

 

-- dba权限操作

-- dba_objects

        created字段   对象的创建时间

        timestamp     对象的最后改动时间

转载于:https://www.cnblogs.com/cici-new/archive/2013/05/06/3063785.html