| Number data type issue [message #394578] |
Fri, 27 March 2009 19:42  |
shrinika
Messages: 306
Registered: April 2008
|
Senior Member |
|
|
I created the table with NUMBER data type. I inserted the number with 54 digit. When i select the data,
it is showing 40 numbers with 14 trailing zeros.. I thought, it rounds to 38 digits... But it is not...
I am using oracle9i version here... Please help me to clarify this..
SQL> create table test(no number);
Table created.
SQL>
SQL> insert into test values(123456789123456789123456789123456789123456789123456789);
1 row created.
SQL> select * from test;
NO
---------------------------------------------------------
123456789123456789123456789123456789123500000000000000
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
