Accepted Answer from pennnn Date: 06/27/2003 06:33AM PDT In SQL the max length is 4000 bytes. In PL/SQL it's 32535. Hope that helps! Comment from MathiasMagnusson Date: 06/29/2003 07:14AM PDT In SQL there is not really a length limit as SQL just refers to already created objects. The difference is that the language PL*SQL can define variables of 32K while tables can only have varchar2 columns of up to 4000 bytes.It may seem that the defference in saying SQL and tables here is splitting hairs. But you can get 32K returned froom a stored procedure or function. So there are situations in SQL where you can have more than 4000 bytes in a varchar2.
In SQL the max length is 4000 bytes. In PL/SQL it's 32535.
Hope that helps!
Comment from MathiasMagnusson Date: 06/29/2003 07:14AM PDT
In SQL there is not really a length limit as SQL just refers to already created objects. The difference is that the language PL*SQL can define variables of 32K while tables
can only have varchar2 columns of up to 4000 bytes.It may seem that the defference in saying SQL and tables here is splitting hairs. But you can get 32K returned froom a stored procedure or function. So there are situations in
SQL where you can have more than 4000 bytes in a varchar2.