10g field varchar size

Giganews Newsgroups
Subject: 10g field varchar size
Posted by:  timasmiā€¦@hotmail.com
Date: 12 Aug 2006


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?