Re: VARCHAR2 Length
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 9 Dec 2009 09:09:19 -0700
Message-ID: <4b1fd9bf$1_at_news.victoria.tc.ca>
The Magnet (art_at_unsu.com) wrote:
Date: 9 Dec 2009 09:09:19 -0700
Message-ID: <4b1fd9bf$1_at_news.victoria.tc.ca>
The Magnet (art_at_unsu.com) wrote:
: So, the max length of VARCHAR2 is 4000 bytes. So, in PL/SQL, if you
: need to declare a variable longer than 4000, what can you use? We
: need to declare a variable and continue to concatenate strings onto it
: and it becomes longer than 4000 bytes, so, we're SOL?
: Still looking for the answer on other sites.
In PL/SQL max length of VARCHAR2 is much longer than in SQL. Received on Wed Dec 09 2009 - 10:09:19 CST