查询数据库最近修改对象

--查询SCM项目最近修改对象
--梁新@2024-03-25
SELECT
	T.OWNER,
	T.OBJECT_NAME,
	T.LAST_DDL_TIME 
FROM
	ALL_OBJECTS T 
WHERE
	T.OWNER IN ( 'MONITOR' ) 
	AND OBJECT_TYPE IN ( 'TABLE', 'VIEW' ) 
	AND T.LAST_DDL_TIME > = TO_DATE( '2024-01-01 23:59', 'YYYY-MM-DD HH24:MI' ) 
ORDER BY
	T.LAST_DDL_TIME DESC;