Re: HELP : Using multiple LONG fields in one table

The varchar2 size in Oracle8 is 4000 characters. More than 2000 yes but I think not enough yet!

Helmut

Greg Kainz wrote:

> 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 Mon Nov 24 1997 - 00:00:00 CST