Oracle ROWSCN Demo - Part 2

oracle-rowscn-demo-part2.sql

var max_row_scn number;

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