Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Internal size of Oracle data types?

Re: Internal size of Oracle data types?

From: Michel Cadot <micadot_at_altern.org>
Date: Tue, 17 Aug 1999 10:08:39 +0200
Message-ID: <7pb5b9$b14$1@oceanite.cybercable.fr>


In version 7.3, you'll find all informations in Oracle7 Server Administrator's Guide, Section Understanding Space Use of Datatypes (pages 10-17 to 10-20).

Mark Huebner a écrit dans le message <37b8c893.7039602_at_news.sprynet.com>...
>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 - 03:08:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US