Re: Oracle NUMBER Datatype question

From: Richard Kuhler <noone_at_nowhere.com>
Date: Tue, 21 May 2002 17:14:07 GMT
Message-ID: <zfvG8.80$R53.158297@twister.socal.rr.com>

For now, number(*,0) == number(38,0) == number(38) == integer

> create table t (c1 number(*,0), c2 number(38,0), c3 number(38), c4 integer);

Table created.

10:10:58 > desc t;
 Name Null? Type

• -------- --------------------- C1 NUMBER(38) C2 NUMBER(38) C3 NUMBER(38) C4 NUMBER(38)

If Oracle decides to increase the maximum precision for the number type (extremely unlikely) then this will change obviously.

Richard

JK wrote:
>
> Does this mean that number(38,0) is
>
> equivalent to number(*,0)
>
> "Richard Kuhler" <noone_at_nowhere.com> wrote in message
> news:NfhG8.19195$V71.7348239_at_twister.socal.rr.com...
> > Type "number(*,0)" holds integers up to 38 digits long. Type "number"
> > holds floating-point numbers with 38 digits of precision.
> >
> > Richard
> >
> >
> > JK wrote:
> > >
> > > What is the difference if any between
> > >
> > > Col1 number
> > >
> > > and
> > >
> > > Col2 number(*,0)
> >
Received on Tue May 21 2002 - 12:14:07 CDT