Re: Physical size of integer

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Sat, 03 Apr 1999 23:26:05 GMT
Message-ID: <371e9f29.6974214@netnews.worldnet.att.net>

No. I believe that Oracle adjusts the physical size of NUMBER fields based on the value that you are storing.

Jonathan

regar

On Sat, 03 Apr 1999 13:07:19 GMT, Info_at_PardoeOnline.com (Guy Pardoe) wrote:

>If I understand the doc correctly, if I create a field in a table with
>the data type of "Integer" it will really be Number(38).
>
>In terms of physical disk storage, this field won't take up thirty
>something bytes, right?
>
>I am used to Visual FoxPro where Integer is a data type taking 4 bytes
>of storage.
>
>Guy Pardoe
>Pardoe Development Corporation
Received on Sat Apr 03 1999 - 17:26:05 CST