oracle查询数据库表最后修改时间
http://blog.csdn.net/accp_fangjian/article/details/6050527
select uat.table_name as 表名,(select last_ddl_time from user_objects where object_name = uat.table_name ) as 最后修改日期
from user_all_tables uat
SELECT OBJECT_NAME ,CREATED FROM ALL_OBJECTS WHERE OBJECT_TYPE=‘TABLE’ AND OWNER=‘TEST’ ORDER BY CREATED DESC; ###查询表创建时间