Slide 28
Slide 28 text
Appendix – Flashback Transaction Query
更新の変遷を Oracle Database で把握する
SELECT versions_xid XID, versions_startscn START_SCN,versions_endscn END_SCN, versions_operation OPERATION,ename, sal
FROM scott.emp
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
WHERE ename = 'SCOTT’;
INSERT INTO EMP VALUES(8888,'JACK','HUMM',8888,to_date('16-1-2023','dd-mm-yyyy'),6500,NULL,10);
commit;
28 Copyright © 2023, Oracle and/or its affiliates
XID START_SCN END_SCN OPERATIOMN ENAME SAL
1661321 SCOTT 3000
05000500B8020000 1661321 U SCOTT 3600
XID START_SCN END_SCN OPERATIOMN ENAME SAL
1661321 SCOTT 3000
05000500B8020000 1661321 U SCOTT 3600
09000700FC020000 1668776 I JACK 6500