摘要: delete from tbndfuture where rowid not in ( select max(rowid) from tbndfuture group by i_code having count(*)>1 union select max(rowid) from tbndfutur 阅读全文
posted @ 2021-07-22 14:43 大龙挂了,公主在哪 阅读(317) 评论(0) 推荐(0)
摘要: SELECT T1.TABLE_NAME 表名, T2.LAST_DDL_TIME 最后修改日期, T2.CREATED 创建日期FROM USER_ALL_TABLES T1LEFT JOIN USER_OBJECTS T2 ON T1.TABLE_NAME = T2.OBJECT_NAMEwhe 阅读全文
posted @ 2021-07-22 11:20 大龙挂了,公主在哪 阅读(200) 评论(0) 推荐(0)