Re: Small Intergers

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 9 Feb 2001 18:16:24 +0100
Message-ID: <t88ao950b3kj7e@beta-news.demon.nl>

Number takes 22 bytes *maximum*,and is of varying length. IMO you shouldn't be concerned, as they are stored as packed decimals. Also: other datatypes are not available.

Hth,

Sybrand Bakker, Oracle DBA

"Joerg Folckers" <jf_at_ecce-terram.de> wrote in message news:3A84097D.CF18D67B_at_ecce-terram.de...
> Hi,
>
> does anyone know how i can get smaller Integers (in storagesize) in
> Oracle 8?
>
> i need Integers that take 16 or 32 bit for there storage (or a bit more)
>
> but not that 22 bytes that the NUMBER Type takes?
>
> maybe someone knows a solution.
>
> thanks beforehand,
> Joerg Folckers.
>
>
>
Received on Fri Feb 09 2001 - 11:16:24 CST