SELECT
T1.TABLE_NAME 表名,
T2.LAST_DDL_TIME 最后修改日期,
T2.CREATED 创建日期
FROM USER_ALL_TABLES T1
LEFT JOIN USER_OBJECTS T2 ON T1.TABLE_NAME = T2.OBJECT_NAME
where t1.table_name = 'TBNDFUTURE'
ORDER BY 最后修改日期 DESC, 最后修改日期 DESC;
2024-01-01 14:38:40
SELECT
T1.TABLE_NAME 表名,
T2.LAST_DDL_TIME 最后修改日期,
T2.CREATED 创建日期
FROM USER_ALL_TABLES T1
LEFT JOIN USER_OBJECTS T2 ON T1.TABLE_NAME = T2.OBJECT_NAME
where t1.table_name = 'TBNDFUTURE'
ORDER BY 最后修改日期 DESC, 最后修改日期 DESC;