Skip to Main Content

SQL & PL/SQL

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!

Need to convert to number from 7.8770E+10

JhilApr 19 2024

Dear Experts,

we want to note SCN, how do i get number of this value (7.8770E+10)

SQL> select current_scn from v$database;

CURRENT_SCN
-----------
7.8770E+10

Thanks

This post has been answered by mathguy on Apr 19 2024
Jump to Answer
Comments
Post Details
Added on Apr 19 2024
4 comments
363 views