DA Morgan schreef:
> 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.
But you cannot use a clob in a where clause
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Sun Aug 13 2006 - 12:24:07 CDT
