Re: How to calculate bytes count of NUMBER(p,s)
From: Tim Smith <tssmith_at_netcom.com>
Date: 1995/10/27
Message-ID: <tssmithDH36FB.51s_at_netcom.com>#1/1
Date: 1995/10/27
Message-ID: <tssmithDH36FB.51s_at_netcom.com>#1/1
jesse_at_ writes:
>The Oracle7 Server Administrator's Guide states the maximum space
>required for datatype of NUMBER is 21 bytes. Is there a formula to
>calculate how many bytes are needed based on precision and scale?
>Any information is appreciated.
Yes. Both the OCI manual (Chapter 3) and the precompiler guide(s) describe the NUMBER datatype internal format in some detail, and give examples. For the precompilers, look at the "generic" _Programmer's Guide to the Oracle Precompilers_, and for Pro*C 2.x, the Pro*C book.
--Tim (tssmith_at_netcom.com (home)) (tssmith_at_us.oracle.com (work)) Received on Fri Oct 27 1995 - 00:00:00 CET