The volume of the known universe (assuming 15 billion light year radius and
a sphere) in cubic inches is like a hundred orders of magnitude less than
the largest number Oracle can handle. (So even switching to cubic nanometers
it is still about 100 orders of magnitude less!)
Jim
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3b651f63$0$8509$ed9e5944_at_reading.news.pipex.net...
> Vincent
>
> Sadly this number is beyond Oracle capabilities From the manual
>
> The following numbers can be stored in a NUMBER column:
>
> a.. Positive numbers in the range 1 x 10-130 to 9.99..9 x 10125 with up
to
> 38 significant digits
> and negative numbers in a similar (but not identical) range.
>
> I must confess I'm intrigued ,and suspicious of, what numbers you are
> holding that go to 10^160. In comparison the age of the universe is
> something like 10^18 seconds (or 16 billion years). Equally the mass of
the
> earth turns out at 10^24 Kg, or thereabouts.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
>
> Legal disclaimer required by my employer
>
> **
> This email contains information intended for the addressee only.
> It may be confidential and may be the subject of legal and/or
professional
> privilege.
> Any dissemination, distribution, copyright or use of this communication
> without prior permission of the addressee is strictly prohibited.
>
> **
> "Vincent" <adonai_at_wish.net> wrote in message
> news:3b6166ee$0$15204_at_reader5...
> > Thanks! That's very nice of you. Is troubleshooting your job?
> >
> > "Jim Kennedy" <kennedy-family_at_home.com> schreef in bericht
> > news:%Z487.413662$p33.8417811_at_news1.sttls1.wa.home.com...
> > > I'll look at this at work.
> > > Jim
> > > "Vincent" <adonai_at_wish.net> wrote in message
> > > news:3b6051b7$0$13153_at_reader4...
> > > > Hello Jim,
> > > >
> > > > First I like to thank you for your reaction.
> > > >
> > > > The exact sql statement is:
> > > >
> > > > INSERT INTO
> > > > "ZONES"
> > > >
> > >
> >
>
("SERIAL","ALIAS_ID1","ALIAS_ID2","ZTYP","ZSTAT","COUNTRY_ID","ADDRESS","NO"
> > > >
> > >
> >
>
,"ZIP_CODE","GIR_CODE","DESCRIPTION","PARENT_ID","XCORD","YCORD","XTOP","YTO
> > > >
> > >
> >
>
P","XBOT","YBOT","XLEN","YLEN","ROTATION","SIZE","PICTURENAAM","ICONNAAM","V
> > > > ALID_YES_NO","COMMENTS")
> > > > VALUES
> > > >
> > >
> >
>
('huis','','','HoofdGebouw',NULL,NULL,'',NULL,'','','','Flevoland',NULL,NULL
> > > >
> > >
> >
>
,0,0,0,0,2.03795089340019E+160,4.84809494615021E-33,NULL,3771.5427114062,NUL
> > > > L,NULL,'','')
> > > >
> > > > The table description is:
> > > >
> > > > Name Null? Type
> > > > ------------------------------- -------- ----
> > > > SERIAL NOT NULL VARCHAR2(128)
> > > > ALIAS_ID1 VARCHAR2(128)
> > > > ALIAS_ID2 VARCHAR2(128)
> > > > ZTYP VARCHAR2(64)
> > > > ZSTAT VARCHAR2(16)
> > > > COUNTRY_ID VARCHAR2(128)
> > > > ADDRESS VARCHAR2(64)
> > > > NO VARCHAR2(8)
> > > > ZIP_CODE VARCHAR2(16)
> > > > GIR_CODE VARCHAR2(8)
> > > > DESCRIPTION VARCHAR2(128)
> > > > PARENT_ID VARCHAR2(128)
> > > > XCORD NUMBER
> > > > YCORD NUMBER
> > > > XTOP NUMBER
> > > > YTOP NUMBER
> > > > XBOT NUMBER
> > > > YBOT NUMBER
> > > > XLEN NUMBER
> > > > YLEN NUMBER
> > > > ROTATION NUMBER
> > > > SIZE NUMBER
> > > > PICTURENAAM VARCHAR2(128)
> > > > ICONNAAM VARCHAR2(128)
> > > > VALID_YES_NO VARCHAR2(3)
> > > > COMMENTS VARCHAR2(255)
> > > >
> > > > The Oracle version is 8.0.5.0.0
> > > >
> > > > I hope you can help me with this one!
> > > >
> > > > Some more information: I have an ODBC connection to Oracle and I
tried
to
> > > > execute this SQL within a Visual Basic program. Doing this results
into
the
> > > > error "ODBC-call failed". After that I have tried this SQL within
TOAD
and
> > > > TOAD tells me that it is a numeric overflow problem.
> > > >
> > > > Reading the Oracle manuals tells me that the maximum number is
9.99x10^125,
> > > > but the value I'm trying to put into that number type field is
2x10^160.
So
> > > > it looks explainable. But it doesn't solve my problem. I need to
have
this
> > > > value in the Oracle database.
> > > >
> > > > Thanks again!
> > > >
> > > > Regards, Vincent
> > > >
> > > >
> > > > "Jim Kennedy" <kennedy-family_at_home.com> schreef in bericht
> > > > news:BrU77.410223$p33.8379060_at_news1.sttls1.wa.home.com...
> > > > > Should work just fine. Can you do a describe on the table that
you
are
> > > > > putting the data into?
> > > > > In sqlplus do
> > > > > desc theTableName
> > > > > Maybe the number is defined to not take it.(you can limit scale
and
> > > > > precision).
> > > > > Also what is the sql statement you are using? Try it from
sqlplus.
> > > > > insert into myTable(col1,col2,...) values( value1,value2,...);
> > > > > commit;
> > > > > Jim
> > > > > "Vincent" <adonai_at_wish.net> wrote in message
news:3b600336$0$7007_at_reader5...
> > > > > > Hello everybody,
> > > > > >
> > > > > > Is it possible to put a value of 2.03795089340019E+160 into a
number
field?
> > > > > > At the moment the value is stored in an Access database double
type
field
> > > > > > and I want to put the data into an Oracle database number type
field
but
the
> > > > > > query gives the error 'ORA-01426: numeric overflow'. For as far
as
I
know
> > > > > > there isn't another datatype available in Oracle. Am I wrong? Do
I
have
to
> > > > > > create an user defined type now? I don't have experience with
that
(but
> > > > > > everything can be learned).
> > > > > >
> > > > > > Thanks in advance,
> > > > > > Vincent
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Received on Mon Jul 30 2001 - 09:07:56 CDT
