Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i view the complete SCN without the exponent thing?

MaxSep 3 2012 — edited Sep 3 2012

DB version: 11.2.0.1.0
Platform : Solaris 10

How can i view the complete SCN without the exponent thing? Currently , it looks like

SQL > select dbms_flashback.get_system_change_number from dual;

GET_SYSTEM_CHANGE_NUMBER
------------------------
              2.2999E+11

 

SQL > select current_scn from v$database;

CURRENT_SCN
-----------
 2.2999E+11

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2012

Added on Sep 3 2012

#general-database-discussions

5 comments

2,281 views