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
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