-
Expert Member
Numeric Data
I created a table for testing purpose
create table xx (a number)
inserting 38 digit number
insert into xx values(11111111111111111111111111111111111111)
inserting 39 digit number
insert into xx values(111111111111111111111111111111111111111)
inserting 126 digit number
insert into xx values(1111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111111)
if i try to insert 127 digit number then it is showing message ora - 01426 numeric overflow.
Precision for oracle numeric data is 38 only. How it is accepting a numeric value upto 126 digits?
Last edited by krishnaindia2007; 02-23-2008 at 07:51 AM.
-
Expert Member
Re: Numeric Data
For Example ,if precision is defined
create table xx (a number(38))
----
inserting 39 digit number
insert into xx values(111111111111111111111111111111111111111)
then it will return error ora-01438
-----
if not defined then
the precision is the maximum number of significant decimal digits i.e 126 binary digits
-
Expert Member
Re: Numeric Data
Whether numeric datatype is fixed length datatype or variable length datatype? i.e. Whether if takes fixed length irrespective of value we stored just like char datatype or it takes space depending on the value we stored?
-
Expert Member
Re: Numeric Data
I found answer. Numbers in an oracle database are always stored as variable length data.
Last edited by krishnaindia2007; 02-26-2008 at 01:14 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules