Re: MAX SIZE FOR A VARCHAR2 Column type

In article <raV3a.23715$rE3.187_at_nwrddc01.gnilink.net>, <sujaykumar_at_hotmail.com says...
>
>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.
>
>--
>Thanks,
>Sujay Kumar
>
>
>

it is documented here:

http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server.920/a96540/sql_elements2a.htm#45510

it is 4000 bytes. to do 20k, you'll want to look at the CLOB datatype.

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp