Re: 10g field varchar size

DA Morgan wrote:
> timasmith_at_hotmail.com wrote:
> > Hi,
> >
> > I apologize I dont know this but when I last designed a schema in
> > Oracle the max varchar2 size was 2000 characters otherwise you had to
> > use Long to get something larger.
> >
> > I believe there are several choices for huge character or binary
> > fields, which require special utilities to qualify in a where clause.
> >
> > My question in 10g+ is
> >
> > a) What is the largest varchar field I can have without losing the
> > ability to qualify it in a where clause
> >
> > b) Is there any restriction on using say clob for many fields on a
> > single table?
> >
> > thanks
> >
> > Tim
>
> The docs are at http://tahiti.oracle.com
>
> VARCHAR2 in a table is 4K
> VARCHAR2 in a variable is 32K
> CLOB will likely do what you want and can be many GB. No restriction.
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Both the Oracle Concepts manual and the Application Developers Guide - Fundamentals contain a chapter on Oracle Database Datatypes.

Daniel gave you one link to online documents. You can also find your way to the documentation via the main Oracle site: http:\\www.oracle.com front page via more than one path. Try Downloads link on left then Documentation link on top.

HTH -- Mark D Powell -- Received on Sat Aug 12 2006 - 15:06:35 CDT