Scientific notation for SCN

From: Ganesh <ganesh.tambat_at_gmail.com>
Date: Tue, 29 Sep 2009 08:12:18 -0700 (PDT)
Message-ID: <ad162079-d05b-4f50-9642-b8768d1935ed_at_s21g2000prm.googlegroups.com>

Can anyone help me understand following:

---

SQL> select MAX(NEXT_CHANGE#) from V$ARCHIVED_LOG;

MAX(NEXT_CHANGE#)

---

       1.3278E+10

SQL> select TO_CHAR(MAX(NEXT_CHANGE#)) from V$ARCHIVED_LOG;

TO_CHAR(MAX(NEXT_CHANGE#))

---

13278230177

SQL> select TO_CHAR(MAX(NEXT_CHANGE#), 999999999999999999999) from V

$ARCHIVED_LOG; TO_CHAR(MAX(NEXT_CHANGE#))

---

13278230177

---

But when I give input 1.3278E+10 to my calculator it returns me the value as 13278000000. So I am not sure why "TO_CHAR" returned 13278230177. So what oracle is doing extra that we are not getting here.

Thanks in advance.
Ganesh Tambat Received on Tue Sep 29 2009 - 10:12:18 CDT