provide some routes maybe useful ...1. Use Trigger to record the modification of the base table to the history table
2. Enable AUDIT functions of the database
3. Some Dictionary Tables like User_Tables , User_Segments tell you the timestamp●龙飞虎○
2. Enable AUDIT functions of the database
3. Some Dictionary Tables like User_Tables , User_Segments tell you the timestamp●龙飞虎○
OBJECT_TYPE, --对象类型
TO_CHAR(CREATED, 'YYYY-Mon-DD HH24:MI') CREATE_TIME, --创建时间
TO_CHAR(LAST_DDL_TIME, 'YYYY-Mon-DD HH24:MI') MOD_TIME, --修改时间
TIMESTAMP, --时间戳
STATUS --状态
FROM USER_OBJECTS
WHERE to_char(LAST_DDL_TIME,'yyyymmdd')>'&日期变量';