Re: Long Char field

From: Peter Dickmann <pdickmann_at_de.lhsgroup.com>
Date: 2000/05/26
Message-ID: <392e3960@news.lhsgroup.com>#1/1

3 pages? You're kidding... A varchar can hold 2k/4k, if this isn't sufficient, you'll need one of the LONG/LOB datatypes, which can hold up to 2GB/4GB, depending on the Oracle version 7/8. LONG is deprecated, use CLOB. You may refer to http://govt.oracle.com/~tkyte/Misc/LargeStrings.html.

Peter

Jose A. Silva <jsilvae_at_yahoo.com> wrote in message news:8gk1d4$ono9_at_nova.entelchile.net...
> Is it posible to store a very large text in oracle ? let's say 3 pages of
> text.
> Thanks.
>
>
Received on Fri May 26 2000 - 00:00:00 CDT