Re: Max Size for VARCHAR2 Column type

Hi,

Varchar2 has a max limit of 4000 character/bytes. If you need to use 20 KB character String then CLOB coould be the best possible. To operate on CLOB you would need to use DBMS_LOB package.

HTH,
Hari

<sujaykumar_at_hotmail.com> wrote in message news:<m8V3a.23706$rE3.1595_at_nwrddc01.gnilink.net>...
> Hi,
> Can anybody specify the max size for a varchar2 column type? What are the
> disadvantages of alloting max size for a VARCHAR2 column? I have a need to
> store more than 20KB of string, and was wondering an easy way of doing it.
Received on Mon Feb 17 2003 - 13:22:24 CET