space usuage of number datatype

From: <gongji_at_my-deja.com>
Date: Tue, 29 Jun 1999 16:00:41 GMT
Message-ID: <7laqj0$jn4$1@nnrp1.deja.com>

Hello:

I have one question about space usuage of number datatype column. I was told that the database assigns a number datatype as fixed space, for example, 21 bytes, nomatter how small digital in number column.

I have lots of table which contains lots of numeric column, but each column has very small digits. If Oracle database really assigns the numeric column like that, my tables eat huge space.

I know database can smartly assign space to the varchar column, that is if the varchar length is small, it gives a small space, if varchar length is big, it gives more. I am just wondering whether database also treats number datatype column like that?

	Does someone know this?
	Thank you very much.

Jin

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 11:00:41 CDT