Re: Difference between Integer and Number

On Wed, 16 Oct 2002 16:06:44 +0200, JW <Benutzer_at_beispiel.net> wrote:

>Hello everybuddy!
>
>I just want to know if there is any difference between the use of
>integer and number as a primary key.
>
>I īve got a database design tool, which handles them identically.
>
>Thanks
>
> James
>

Hi James,

Oracle stores INTEGER internally as a NUMBER(38).

So the answer must be : Yes, an INTEGER differs from a NUMBER(p,s), unless you specify NUMBER(38,0) or NUMBER(38);

• Kenneth Koenraadt