linux 查看flash版本号,FLASHBACK的多版本查询

cola for 99999999999999999999selecttimestamp_to_scn(to_timestamp('2011-01-24 16:17:38','yyyy-mm-dd hh24:mi:ss')) a from dual;

A

---------------------

9496255704078

selecttimestamp_to_scn(to_timestamp('2011-01-24 16:28:52','yyyy-mm-dd hh24:mi:ss')) a from dual;

A

---------------------

9496256954638

SELECTmember_id,modifier,gmt_modified

VERSIONS_STARTSCN,

VERSIONS_ENDSCN,

VERSIONS_OPERATION,

VERSIONS_XID

FROM global_account_biz VERSIONS BETWEEN SCN 9496255704078 AND 9496256954638

where global_id=382152708 order by VERSIONS_STARTSCN;

MEMBER_ID       MODIFIER        VERSIONS_STARTSCN   VERSIONS_ENDSCN VE VERSIONS_XID

--------------- --------------- ------------------- --------------- -- ----------------

zhiyuanyinhua   modifier        2011-01-24 16:16:04      9.4963E+12 U  001000010017CDA4

zhiyuanyinhua   xzhuxiaona      2011-01-24 16:16:19      9.4963E+12

xzzyyh          xzhuxiaona      2011-01-24 16:17:38      9.4963E+12 U  0026000700107ADE

xzzyyh          esbService      2011-01-24 16:17:39      9.4963E+12 U  00010010001A576F

zhiyuanyinhua   xzhuxiaona      2011-01-24 16:21:52      9.4963E+12 U  002500140010C5CA

xzzyyh          synAvInfoByEsb  2011-01-24 16:21:54      9.4963E+12 U  0039001500081F27

xzzyyh          esb             2011-01-24 16:24:29                 U  0039001600083F4C