Re: INTEGER datatype

From: Valery Yourinsky <vsu_at_bill.mts.ru>
Date: Tue, 25 Dec 2001 09:08:05 +0300
Message-ID: <3C2817C5.FE0C2DE1@bill.mts.ru>

Murty Adavi wrote:
>
> What is the difference between datatypes INTEGER & NUMBER(p) in Oracle?
> I don't see much documentation about INTEGER datatype anywhere. Is it an
> outdataed one
> being supported for backward compatability reasons ?
>
> The reason I am asking is I need to convert a Sybase database to Oracle and
> want to know
> the Sybase INTEGER's equivalent in Ocalce.

ANSI INTEGER is equivalent to Oracle NUMBER(38)

See
Oracle8i. SQL Reference. Release 3 (8.1.7). September 2000

             Part No. A85397-01
      2. Basic Elements of Oracle SQL
         Datatypes
            ANSI, DB2, and SQL/DS Datatypes

Valery Yourinsky

-- 
Oracle8 Certified DBA
Moscow, Russia

Received on Tue Dec 25 2001 - 00:08:05 CST