On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

Wednesday, September 3, 2008

SCN - System Change Number

To get the last change number:

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