limit of varchar2

From: Zeyad S <sweidanz_at_yahoo.com>
Date: Thu, 17 May 2001 16:33:27 +1000
Message-ID: <3B0370B6.36993F3C@yahoo.com>

Folks,
In Oracle documentation, specifically Application Developer's Guide, they mention the following:

Varchar2(size) Variable for each row, up to 4000 bytes per row. consider the character ser(one-byte or multibyte) before setting size.

My question is: is the 4000 bytes is really the maximum bytes per row or there is something misleading here? I tried it and create a table with more than two fields one with varchar2(4000) and the other with varchar2(200) without any problem. Also i inserted two records and retieved them without any problem.

Am I missunderstanding something here? and when should i consider using CLOB datatypes?

Thanks,
Zeyad Received on Thu May 17 2001 - 01:33:27 CDT