Re: Internal size of Oracle data types?

Hi Mark

take a look to the concepts documentation from Oracle.

--
Best regards

Ralph Ganszky

• The above opinions are mine and do not represent any official
• standpoints of my employer or third party organizations.

Mark Huebner wrote:

> Could somebody tell me what the size of Oracle 7/8 data types is? Is
> this information in any book? Is a NUMBER data type always 16 bytes
> long? Does Oracle store numbers in less space (less than 16 bytes) if
> the precision is specified (e.g., NUMBER(5,2))? Does a NUMBER(5,2)
> take less space than a NUMBER(8,3)? How big is a SMALLINT, a DATE,
> etc? Are there any performance considerations?
>
> Thanks in advance.
>
> Mark Huebner
> mkhuebner_at_sprynet.com
Received on Tue Aug 17 1999 - 05:40:27 CDT