SELECT * FROM dba_objects obj WHERE obj.OWNER=‘用户名’ and obj.OBJECT_TYPE=‘TABLE’ AND obj.CREATED BETWEEN ‘开始时间’ AND ‘结束时间’ ORDER BY obj.CREATED DESC;
ORACLE查询新建的表
最新推荐文章于 2022-04-25 18:53:32 发布
SELECT * FROM dba_objects obj WHERE obj.OWNER=‘用户名’ and obj.OBJECT_TYPE=‘TABLE’ AND obj.CREATED BETWEEN ‘开始时间’ AND ‘结束时间’ ORDER BY obj.CREATED DESC;