Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Diskspace of a Number column in Oracle 8/9
"J.Bokma" wrote:
> Hello Everyone,
>
> My question is how many bytes of diskspace a number column takes .
> Both for NULL value and when it is NOT NULL.
> Is it different in Oracle 7 8 and 9
>
> Any suggestions ?
> JB
Insert a bunch of numbers into a column and then perform the following:
SELECT dump(<column_name>)
FROM <table_name>;
Daniel Morgan Received on Sun Apr 20 2003 - 12:47:52 CDT