Re: Internal storage numbers

From: David <darussell_at_email.msn.com>
Date: Sun, 27 Sep 1998 21:46:11 +0100
Message-ID: <OXn9Dgl69GA.289@upnetnews05>

To determine the space usage for a column use vsize (e.g. select vsize(col1) ....), Oracle do not document the storage algorithm. You should find that the maximum space usage for a number(10) will be 6 bytes.

Regards
David

David wrote in message <360db3b6.0_at_news1.ibm.net>...
>I have 2 questions that relate to the number datatype;
>
>1. Do columns number(10) and number use the same amount of internal
>storage?
>2. How storage does number and number(10) use?
>
>Thanks in advance
>
>
Received on Sun Sep 27 1998 - 15:46:11 CDT