Sunday, March 29, 2009

Timestamp and SCN Conversion

You can convert timestamp into SCN and vice versa.

SQL> Select current_scn, systimestamp, timestamp_to_scn(systimestamp), scn_to_timestamp(current_scn) from v$database;

Thanks

No comments:

Followers

Powered By Blogger
 

Oracle Database Administration. Copyright 2008 All Rights Reserved Revolution Two Church theme by Brian Gardner Converted into Blogger Template by Bloganol dot com