摘要：https://www.cnblogs.com/jackyfei/p/9955108.html 阅读全文

摘要：select versions_starttime, versions_endtime, versions_xid, versions_operation ,'insert into scott.a values('||id||','||name||')' --id和name是这个表的字段 from 阅读全文

摘要：--注意权限问题 1.查看是否有被锁的表： select b.owner,b.object_name,a.session_id,a.locked_modefrom v$locked_object a,dba_objects b where b.object_id = a.object_id 2.查看 阅读全文

摘要：https://blog.csdn.net/u013986802/article/details/71214312 --这个较全 https://www.cnblogs.com/zhangkaimin/p/11720239.html --自动分区 https://www.cnblogs.com/ge 阅读全文

摘要：select t.* from tablename t inner join (select t.xxx, max(DATE_TIME) date_time from tablename1 t group by t.xxx) n on t.xxx = n.xxx and t.date_time = 阅读全文