在提交之前查看不同SQL Oracle会话的更改？

-- 启用闪回查询
BEGIN
  DBMS_FLASHBACK.ENABLE_AT_SYSTEM_CHANGE_NUMBER(123456789);
END;
/

-- 查询当前状态
SELECT * FROM your_table;

-- 禁用闪回查询
BEGIN
  DBMS_FLASHBACK.DISABLE;
END;
/

-- 查看当前会话的事务信息
SELECT s.sid, s.serial#, t.start_time, t.status
FROM v$session s
JOIN v$transaction t ON s.saddr = t.ses_addr;

-- 查看特定会话的更改
SELECT * FROM v$session s
JOIN v$transaction t ON s.saddr = t.ses_addr
WHERE s.sid = 123;

-- 启动LOGMINER
EXECUTE DBMS_LOGMNR.START_LOGMNR(
  STARTTIME => TO_DATE('2023-04-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),
  ENDTIME => TO_DATE('2023-04-01 23:59:59', 'YYYY-MM-DD HH24:MI:SS')
);

-- 查询更改
SELECT * FROM V$LOGMNR_CONTENTS;

-- 停止LOGMINER
EXECUTE DBMS_LOGMNR.END_LOGMNR();

-- 查看表在某个时间点的状态
SELECT * FROM your_table AS OF TIMESTAMP TO_TIMESTAMP('2023-04-01 12:00:00', 'YYYY-MM-DD HH24:MI:SS');