Re: Physical Storage Requirements for NUMBER attributes.
From: Tim Smith <tssmith_at_netcom.com>
Date: Fri, 24 Mar 1995 18:37:44 GMT
Message-ID: <tssmithD5yJqw.3J6_at_netcom.com>
Date: Fri, 24 Mar 1995 18:37:44 GMT
Message-ID: <tssmithD5yJqw.3J6_at_netcom.com>
170sys_at_netcom.com (Dan Kennedy) writes:
>For NUMBER columns the size only indicates the maximum size
>of the column. To find out how much space is actually being
>used to store a particular value use the VSIZE function in
>a select statement.
Also, the internal storage format of NUMBERs is documented in the OCI and precompiler guides. Look under NUMBER or VARNUM in the indexes to see where. (Oracle stores numeric values internally ONLY in the NUMBER format, regardless whether integer or real.)
--Tim (tssmith_at_oracle.com) Received on Fri Mar 24 1995 - 19:37:44 CET