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: Is there an INTEGER datatype

Re: Is there an INTEGER datatype

From: Joerg Lanzinger <joerg_at_lanzinger.de>
Date: Mon, 25 Oct 1999 13:48:36 +0200
Message-ID: <38144394.A2F66E75@lanzinger.de>


Hello,

one reason I choose INTEGERS was the dtorage the table will need. But as you can easily test using the VSIZE operator, Oracle just uses as may bytes as minimaly needed.

CU
  Joerg

Doug Cowles schrieb:

> I guess that's my original confusion - under ANSI datatype support, it
> indicates that most of these datatypes are really under the covers
> converted to variations of NUMBER. If this is the case, then I don't
> see any reason to use them. Is this true? And what does everyone else
> think?
>
> - D
>
> fumi wrote:
>
> > Doug Cowles <dcowles_at_nospambigfoot.com> wrote in message
> > news:37FED0DB.DEE58F0D_at_nospambigfoot.com...
> > > Any idea where I can find some documentation on these?
> > >
> > > Terry Dykstra wrote:
> >
> > Take a look at "Datatype - ANSI datatype support" in the Oracle SQL
> > Reference.
Received on Mon Oct 25 1999 - 06:48:36 CDT

Original text of this message

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