一问一答：如何获得当前行的scn？

答：使用这个包dbms_rowid 的函数rowid_block_number(rowid) 获得block号，dbms_flashback.get_system_change_number 为当前行的scn

举例如下：

  select a1,a2,dbms_rowid.rowid_block_number(rowid) block#,dbms_flashback.get_system_change_number scn from test_gao.t;

        A1 A2             BLOCK#        SCN
---------- ---------- ---------- ----------
         1 2               28090     827697
         1 2               28090     827697
         1 2               28090     827697
         1 3               28090     827697