Re: Scientific notation for SCN
Date: Tue, 29 Sep 2009 17:36:18 +0200
Message-ID: <4ac2296f$0$31139$426a34cc_at_news.free.fr>
"Ganesh" <ganesh.tambat_at_gmail.com> a écrit dans le message de news:
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
set numwidth 20
Regards
Michel
Received on Tue Sep 29 2009 - 10:36:18 CDT