Re: datatype restrictions

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Thu, 12 Jul 2001 01:17:17 GMT
Message-ID: <xU637.333626$p33.6726928@news1.sttls1.wa.home.com>

Long is not a mathematical or a C long (a large integer number e.g. 2^32) it is a large field for character data. It can hold up to 2 gigs of character data. If you are using Oracle 8 or above I suggest you use LOB's and not longs since longs are deprecated.

In Oracle there is a numeric type (up to 38 digits of precision). It has a scale and a precision component. I believe numbers can go up to 10^308. Jim
"Marko Opic" <marko_at_opic.de> wrote in message news:3b4c37b5_1_at_news.arcor-ip.de...
> Can someone tell me, what datatype restrictions oracle has?
>
> For example: For which numbers is "long" a valid datatype?
>
>
> I need this info for some number- and string-datatypes.
>
> Thank you,
>
> Marko Opic
>
>
Received on Wed Jul 11 2001 - 20:17:17 CDT