Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Diskspace of a Number column in Oracle 8/9

Re: Diskspace of a Number column in Oracle 8/9

From: Daniel Morgan <damorgan_at_exesolutions.com>
Date: Sun, 20 Apr 2003 10:47:52 -0700
Message-ID: <3EA2DD48.C64DD30D@exesolutions.com>


"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US