摘要:
查看死锁 select object_name,machine,s.sid,s.serial# from v$locked_object l,dba_objects o ,v$session s where l.object_id = o.object_id and l.session_id=s.s 阅读全文
摘要:
select * from '需要恢复数据的表名' as of timestamp to_timestamp('2020-01-01 00:00:00', 'yyyy-mm-dd hh24:mi:ss') where name = 'zhangsan'; * name=zhangsan是查询条件 ! 阅读全文