Script – List all recent DDL modifications

最新推荐文章于 2023-09-02 11:41:55 发布

leishifei

最新推荐文章于 2023-09-02 11:41:55 发布

阅读量301

点赞数

分类专栏： Oracle Scripts 文章标签： list object date

本文链接：https://blog.csdn.net/leishifei/article/details/6432404

版权

Oracle Scripts 专栏收录该内容

45 篇文章 0 订阅

订阅专栏

Script – List all recent DDL modifications

set pagesize 200 colsep ' '
col Owner format a20
col Object_Name format a30
col Last_DDL format a20
break on Owner
select Owner, Object_type
Object_Name,
Timestamp Last_DDL
from DBA_OBJECTS
where  SysDate - TO_DATE(TimeStamp,'YYYY-MM-DD:HH24:MI:SS') < 1
order by Owner, Object_Name
/