Re: INTEGER type in Oracle ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Mon, 06 Mar 2000 17:55:23 +0800
Message-ID: <38C3808B.4C6A@yahoo.com>

Garry Star wrote:
>
> Can someone please explain to me how you store/retrieve an integer value in
> Oracle 8.x? I haven't had an problem in Access, SQLServer, or Sybase but
> Oracle is different.
>
> I'm using ODBC driver but I can't even set a field's type to integer in the
> Schema Manager.
>
> All I can see is NUMBER type and that allows me to write an integer into it,
> but converts it to a floating point value and when I read it, it is returned
> as a double.
>
> I know this must be easy, but I haven't been able to find anything in
> multiple newsgroups, FAQs, dejanews.com, Oracle's tech web site, or
> documentation on the CD,
>
> Thanks in advance...
>
> Garry
> garry_star_at_ads-associates.com

Try NUMBER(n) which is "equivalent" to integers.

HTH
--

---

Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse Received on Mon Mar 06 2000 - 03:55:23 CST