Oracle Flashback Technologies - 闪回查询
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了Oracle Flashback Technologies - 闪回查询,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2015字,纯文字阅读大概需要3分钟。
内容图文
![Oracle Flashback Technologies - 闪回查询](/upload/InfoBanner/zyjiaocheng/1115/8147d2c3881a4211a9ebf11154c3793c.jpg)
Oracle Flashback Technologies - 闪回查询
查看表中,某行数据的修改记录
#创建一个表,并插入和修改数据
SQL> create table y3(id int,name varchar2(20)); Table created. SQL> insert into y3 values(1,‘wahaha‘); 1 row created. SQL> commit; Commit complete. SQL> update y3 set name=‘nongfushanquan‘where id=1; 1 row updated. SQL> commit; Commit complete. SQL> update y3 set name=‘kaifei‘where id=1; 1 row updated. SQL> commit; Commit complete. SQL> update y3 set name=‘pijiu‘where id=1; 1 row updated. SQL> commit; Commit complete. SQL> update y3 set name=‘hongniu‘where id=1; 1 row updated. SQL> commit; Commit complete. SQL> update y3 set name=‘kele‘where id=1; 1 row updated. SQL> commit; Commit complete. SQL>
#查询
#查询 SQL> select2 name, 3 versions_starttime, 4 versions_startscn, 5 versions_endtime, 6 versions_endscn, 7 versions_xid, 8 versions_operation 9from y3 10 versions between scn minvalue and maxvalue 11where id = 112 order by 313 / NAME VERSIONS_STARTTIME VERSIONS_STARTSCN VERSIONS_ENDTIME VERSIONS_ENDSCN VERSIONS_XID V -------------------- ------------------------- ----------------- ------------------------- --------------- ---------------- - wahaha 23-JUN-1508.36.07 AM 146631823-JUN-1508.36.46 AM 14663330400200065030000 I nongfushanquan 23-JUN-1508.36.46 AM 146633323-JUN-1508.37.16 AM 1466347 0A00040015040000 U kaifei 23-JUN-1508.37.16 AM 146634723-JUN-1508.37.31 AM 1466355 070018009D030000 U pijiu 23-JUN-1508.37.31 AM 146635523-JUN-1508.37.49 AM 1466364 01000D0048030000 U hongniu 23-JUN-1508.37.49 AM 146636423-JUN-1508.39.04 AM 1466400 02001B0021040000 U kele 23-JUN-1508.39.04 AM 1466400 06000400DC040000 U 6 rows selected. SQL>
查看语句
select name, versions_starttime, versions_startscn, versions_endtime, versions_endscn, versions_xid, versions_operation from y3 versions between scn minvalue and maxvalue #versions between timestamp minvalue and maxvalue 也可以根据时间戳来查看 where id = 1 order by 3 /
原文:http://www.cnblogs.com/abclife/p/4595843.html
内容总结
以上是互联网集市为您收集整理的Oracle Flashback Technologies - 闪回查询全部内容,希望文章能够帮你解决Oracle Flashback Technologies - 闪回查询所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。