Re: 10g field varchar size

Giganews Newsgroups
Subject: Re: 10g field varchar size
Posted by:  DA Morgan (damorg…@psoug.org)
Date: Sat, 12 Aug 2006

timasmi…@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 athttp://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
damorg…@x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Replies

In response to

10g field varchar size posted by timasmi…@hotmail.com on 12 Aug 2006