Re: Oracle datatypes?

From: Sunny <sunnyb_at_vendtek.bc.ca>
Date: 2000/06/12
Message-ID: <8i3kn4$q47$1@newsfeed.smartt.com>#1/1

There you go, this might help you out

CHAR: Maximum size is up to 2000

VARCHAR2: up to 4000

NUMBER: I think, maximum can be up to 40 digits plus space for a decimal point and sign

LONG: up to 2GB in length

DATE: you can put any dates from January 1, 4712 BC to December 31, 4712 AD

FLOAT: same as a number

Hope it helps

<jazzy6591_at_my-deja.com> wrote in message news:8hon9e$aje$1_at_nnrp1.deja.com...
> I am searching for information that contains a list of the maximum
> column size of these datatypes within oracle: VARCHAR2, NUMBER, LONG,
> DATE, CHAR, FLOAT. Do anybody know where can i find this information?
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jun 12 2000 - 00:00:00 CDT