Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP : Using multiple LONG fields in one table

Re: HELP : Using multiple LONG fields in one table

From: Greg Kainz <gkainz_at_orapro.com>
Date: 1997/11/19
Message-ID: <34736297.3CEA2E17@orapro.com>#1/1

Michael is right in that Oracle8 only allows one column of type LONG. However, the size limits of varchar2 have been expanded greatly (2M)? I don't recall the exact size off the top of my head, but I can find no compelling reason to need more than one LONG column with the new sizes available....

Michael Jenc wrote:

> Nick Strange wrote:
> >
> > Not until oracle 8.
 

> Hi!
 

> You are wrong! Oracle 8 also allows you only to have one long
> column per table. And this is a VERY POOR limit.
> Bye
> Michael
>
> >
> > sector Sociale Zaken <wdverba_at_wirehub.nl> wrote in article
> > <01bcf045$ed8642a0$4389b0c1_at_pudevserver>...
> > > Hi all,
> > >
> > > Is it possible to use multiple LONG fields in one table.
Received on Wed Nov 19 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US