> Hi!
>
> I have a question concerning datatypes in Oracle. What do you
> think about this? Would it be a good idea to use INTEGER
> instead of NUMBER datatype for PK columns generated by
> sequences? There's always only gonna be 'regular' numbers in
> that column (e.g. 1, 2, 3, 4, ..., 1457, 1458 etc.)
>
> What is the advantage/disadvantage of using one over the other?
>
> This is the request from one of our lead developers:
>
> > For some reason, unknown to me, we have always used the
> > datatype NUMBER to represent Integers in the database.
> > I do not understand why we do not use INTEGER type when we
> > need an Integer,
> > and I would request that in the future, we use type INTEGER
> > unless there is a reason for not doing so.
> > I ran into a problem reverse-engineering the DB in Rational
> > Rose, because it
> > turned the NUMBER fields into FLOAT type in the model. I
> > reported this as a
> > bug to Rational, and thir response is included below:
>
>
> Any idea?
>
>
> This is 8.1.6 on Win2k.
>
Received on Mon Jan 22 2001 - 23:29:27 CST
