Re: Small Intergers

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Fri, 09 Feb 2001 21:35:29 -0800
Message-ID: <3A84D321.63773F20@exesolutions.com>

Correct. Most numbers on Oracle are 4 or 5 bytes.

The vsize() function will return the number of bytes.

Daniel A. Morgan

Sybrand Bakker wrote:

> 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 - 23:35:29 CST