Re: varchar2(4000)

Hi Rahul/List,

In Oracle 8i manual the definition of Varchar2 is given as

 VARCHAR2(size)
 Variable-length character string having maximum length size bytes. Maximum size is 4000, and minimum is 1. You must specify size for VARCHAR2. I guess it means that max is 4000 bytes, and not characters. I even went further and tried the following insert ..............

insert into test values(rpad

('rahul',9999999999999999999999999999999999999999999
9999999999999999999999999999999999999999999999999999,'x'))

But this is not the max limit........................................

                                   shreepad.