Oracle ROWSCN Demo - Part 3

oracle-rowscn-demo-part3.sql

SELECT 'Updating 1 record in table ...' STATUS_MSG FROM DUAL;
UPDATE t
   SET y = 'DUAL123'
 WHERE x = 1;

COMMIT;

SELECT 'Fetching changed data in table ...' STATUS_MSG FROM DUAL;
SELECT t.*
       -- dbms_rowid.rowid_block_number (ROWID) blockno,
       -- SCN_TO_TIMESTAMP (t.ORA_ROWSCN),
       -- t.ORA_ROWSCN
  FROM t
  WHERE t.ORA_ROWSCN > :max_row_scn;

SELECT 'Resetting max scn ...' STATUS_MSG FROM DUAL;
BEGIN	
	SELECT MAX(ORA_ROWSCN) max_row INTO :max_row_scn FROM T;
END;
/

print max_row_scn