如何在sql数据库中查看近期数据库对象的修改日志,参考如下sql语句:
复制代码 代码示例:
select
object_name 对象名,
object_type 对象类型,
to_char(created, 'yyyy-mon-dd hh24:mi') 创建时间,
to_char(last_ddl_time, 'yyyy-mon-dd hh24:mi') 修改时间,
timestamp 时间戳,
status 状态
from user_objects where object_type = 'table' order by 修改时间 desc