Re: Physical Storage Requirements for NUMBER attributes.

DPWCC02.OBERLE02_at_SSW.ALCOA.COM (Oberle, John F.) wrote:
>
> I have inherited a database with many fields having the default
> of NUMBER(38). In a similar ORACLE (DEC) Rdb database those
> fields are defined as integers which take 1 word to store. How
> much space does a NUMBER(38) take? Is there a way to dump data
> from an ORACLE database to examine what the physical storage
> looks like?
>
> Thanks in advance
>
> John F. Oberle
>

You can use the following to get the storage required:

select vsize(column_name) from table_name where primary_key=value;

Good Luck
Phillip A. Gingras
CHC Received on Fri Mar 24 1995 - 20:12:16 CET