Wednesday, September 3, 2008

SCN - System Change Number

To get the last change number:
Commit;

Variable Scn_Flash Number;
Execute :Scn_Flash := Dbms_Flashback.Get_System_Change_Number;

Column Scn_Flash Format 999,999,999
Print Scn_Flash

No comments:

Post a Comment