Oracle Flashback Technologies-Flash back query

Oracle Flashback Technologies-Flash back query

View the modified record of a row of data in a table

#创建一个表, and insert and modify data

Sql> CREATE TABLE Y3 (IDint, Name VARCHAR2 ( -)); Table created. SQL> INSERT into Y3 values (1,'Wahaha');1row created. SQL>commit; Commit complete. SQL> Update Y3SetName='Nongfushanquan' whereId=1;1row updated. SQL>commit; Commit complete. SQL> Update Y3SetName='Kaifei' whereId=1;1row updated. SQL>commit; Commit complete. SQL> Update Y3SetName='Pijiu' whereId=1;1row updated. SQL>commit; Commit complete. SQL> Update Y3SetName='Hongniu' whereId=1;1row updated. SQL>commit; Commit complete. SQL> Update Y3SetName='Kele' whereId=1;1row updated. SQL>commit; Commit complete. SQL>

#查询

#查询SQL>Select  2name,3Versions_starttime,4VERSIONS_STARTSCN,5Versions_endtime,6VERSIONS_ENDSCN,7Versions_xid,8versions_operation9    fromY3Tenversions between SCN MinValue and MaxValue One   whereID =1  AORDER BY3  -/NAME versions_starttime versions_startscn versions_endtime versions_endscn versions_xi D V-------------------- ------------------------- ----------------- ------------------------- --------------- --------- ------- -Wahaha at-jun- the 08.36. -Am1466318  at-jun- the 08.36. $Am1466333 0400200065030000Inongfushanquan at-jun- the 08.36. $Am1466333  at-jun- the 08.37. -Am14663470a00040015040000 Ukaifei at-jun- the 08.37. -Am1466347  at-jun- the 08.37. toAm1466355070018009d030000 Upijiu at-jun- the 08.37. toAm1466355  at-jun- the 08.37. theAm146636401000d0048030000 Uhongniu at-jun- the 08.37. theAm1466364  at-jun- the 08.39.GenevaAm146640002001b0021040000 Ukele at-jun- the 08.39.GenevaAm146640006000400dc040000 U6rows selected. SQL>

View statements

 Select from where13/

Oracle Flashback Technologies-Flash back query