How to define a string field that is bigger than 2k?

[wminghao]

I need to create a table, in which there is a field called Description, i try to make it as VARCHAR2 size 10k, but the max length of VARCHAR2 is 2k, is there any other type that can have a size bigger than 2k?

How to define a string field whose size is bigger than 2k in Oracle?

Mollusk

 

[sem]

The largest size of varchar2 in Oracle 8 is 4K, though for your task you may try to use CLOB. Its size limit is 4G.